Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel keyboard shortcuts (Read 1669 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Excel keyboard shortcuts
16.09.08 at 20:23:59
Excel keyboard shortcuts
MS Excel keyboard shortcuts:
Selecting cells:
CTRL+*      Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
CTRL+a    Selects all cells in the current spreadsheet
CTRL+SPACEBAR selects an entire column in a worksheet.
SHIFT+SPACEBAR selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR selects the entire worksheet.
Ctrl-[ : Jump to a cell that is used in the formula in the cell
Ctlr-] : Jump to a cell that is referencing the current cell
CTRL+~      Applies the General number format.
CTRL+%      Applies the Percentage format with no decimal places.
CTRL+^      Applies the Exponential number format with two decimal places.
CTRL+#      Applies the Date format with the day, month, and year.
CTRL+@      Applies the Time format with the hour and minute, and AM or PM.
CTRL+!      Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+1    Format cells dialog
CTRL+D    Copied the top cell + formatting down
F2 : Edit formula
CTRL+`      Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+-     Delete selected cells
CTRL++    Show insert cells dialog. If a range is selected it will insert the size of the selected range.
CTRL+Y      Repeats the last command or action, if possible.
CTRL+ALT+v    Paste Special
Back to top
« Last Edit: 13.12.09 at 19:36:31 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Re: Excel keyboard shortcuts
Reply #1 - 11.05.15 at 13:55:46
Excel Keyboard Shortcuts
1. Shift + F10 – The Right Click pop up open
Most of the time users suffer to have the right click shortcut while working on any database. By pressing shift + F10, you can open the right click menu. You can use up / down arrow keys to move to various options. The right arrow key is used to open fly-out menu. Hit enter when you get to the item you want.
2. Ctrl + 1 – Open “Format Cells” dialog box
It is one of the most influential and time saving shortcuts in Excel. It enables the user to skip all the long procedure to format cells, charts, text boxes, etc. to make life easy.
3. Ctrl + 5 – Applies or remove strike-through
We all make list on excel and wants to cross it off once it’s done. It gives us feel like we have finished our tasks. Select a cell or range and then press CTRL + 5 to apply strike-through to the cell / range.
4. Ctrl + 9 – Hide the complete row
In Excel, move anywhere in a row you want to hide and then press CTRL + 9.The entire current row is hidden. You can also use Shift+Up arrow or Shift+Down arrow to select several rows.
5. Ctrl + SHIFT + L – Turn on / off filter
One of the powerful and useful shortcuts (CTRL + SHIFT + L) while working on large data set especially when you set few filters on, and then want to return back to the full view of data clearing all filters.
6. Ctrl + * – Select the current region
Select the current range by pressing CTRL + asterisk key, which is the complete data set, in all directions from the current cell until Excel hits the edge of the worksheet.
7. F4 – To repeat last action
F4 is one of the best shortcuts in Excel and there are various ways to use it. It saves the user from keystrokes and mouse involvement. If you are not editing a cell, it repeats the last command or action. For example, if you have just deleted a row and you want to delete another row, simply select the range where you want to delete the next row and press F4.
8. F4 – Set cell references or add dollar sign to a reference
F4 cycles through all 4 types of cell references (absolute, mixed reference (2x) and relative). It helps to change the reference style from relative (A1) to absolute ($A$1). It is very useful when you want to take formula from one cell to other cell but want to keep the same reference in the formula.
9. Ctrl + T – To Insert a Table
In Excel, Tables are very flexible and easy to work. Especially to convert bunch of data into table.To make it in table, select any cell in the spreadsheet (with our without data) and press CTRL+ T. If your spreadsheet contains header cells, you might need to check the My Table Has Headers option.
10. Shift + F2 – Insert / edit comment  
This shortcut will help you to add or edit the comment easily.
Back to top

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1