Posts tagged excel
Some shortcut keys in Excel
Jan 31st
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.
Shortcut keys in Excel
Dec 15th
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

Recent Comments