List_Management_Tips

List_Management_Tips - Excel List Management Tips 2001-2002...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Excel List Management Tips 2001-2002 What characterizes an Excel list = row = record = column = field = header row = 1 st row; formatted differently = no blank rows or columns in the data (though blank cells within records are OK) = formulas to calculate data items are OK Excel list example Excel list navigation tips Move to list corners CTRL+arrow keys Select a single record CTRL+SHIFT+right arrow Select the entire list quickly CTRL+* (e.g., CTRL+SHIFT+8) Move between the 4 corners of a selected range CTRL + . (e.g., CTRL + period)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Excel Data Addition Tips Insert current date CTRL + ; (e.g., CTRL + semicolon) Insert current time CTRL + : (e.g., CTRL + colon) Autocomplete “Pick from List” Start in a blank cell beneath a list column and press ALT + down arrow to see a pick list. Or right click and choose Pick from List . Excel’s Data Form To start: With the insertion point anywhere in the list, choose Data, Form from the menus. Features:
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

List_Management_Tips - Excel List Management Tips 2001-2002...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online