Posts tagged excel

Ctrl+Shift+O: To select all the cells with comments. If there are no cells with contents then you will get ‘No cells found’ message.

Ctrl+[ : To show which are the related cells in the selected formula.

Ctrl+] : To show the related formulas of the selected cell.

Shift+Arrow key : The selection will be extended to one more adjacent cell.

Ctrl+Shift+Arrow key : The selection will be extended to the last cell with data either horizontally or vertically based on your current selection.

Shift+Home : The selection will  be extended to the first cell horizontally.

Ctrl+Shift+Home : Selection will be extended to the first cell in the worksheet.

Ctrl+Shift+End: Selection will be extended until the last cell in the worksheet/.

Enter: Cursor will be moved to the next cell below the current cell.

CTRL+SPACEBAR : The active column will be selected.
SHIFT+SPACEBAR : The active row will be selected.
CTRL+HOME :To goto the start of the worksheet
CTRL+END:  To goto the end of the worksheet
SHIFT+F3 : To add a function in the formula
CTRL+A: When entering a formula, after typing the function name the formula pallette will be shown.
CTRL+A: When a formula is not entered or edited, the whole sheet will be selected.
CTRL+‘ : (Single left quotation mark) Cell valye and cell formula will be shown next to each other
F11 or ALT+F1: The chart will be produced based on the selected range.
CTRL+;  (semi colon) to insert the date
CTRL+:  (colon) To insert time
CTRL+ENTER: to create entry in the selected range
F5: to show the "Go To" dialog box
CTRL+1: to show the "Format Cells" dialogn box
CTRL+C: to copy
CTRL+V: to paste
CTRL+Z:  to undo
CTRL+S: to save
CTRL+P: to print
CTRL+O: to open a new file