Formatting in cells of Excel – 3 of 8

peacock : image source- Unsplash/andre-mouton

I have given you two lists of very useful shortcut keys General and Navigational keys to use in Excel. Here is the third of the series of 8 using Formatting. Shortcut keys are a quicker way of executing certain commands. They also save your fingers from repetitive strain syndrome from using the mouse. As I have said before, please don’t think you need to learn each and every shortcut. They are only a quicker way if you remember them. Additionally, learning all of them is a bit hard if you don’t use them regularly. So highlight the ones you like and use and keep the list for another day when you may want a new shortcut key to learn.

Format in cells: keyboard shortcuts
To do this Press
Open the Format Cells dialog box. Ctrl+1
Format fonts in the Format Cells dialog box. Ctrl+Shift+F or Ctrl+Shift+P
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. F2
Add or edit a cell comment. Shift+F2
Open the Insert dialog to insert blank cells. Ctrl+Shift+Plus (+)
Open the Delete dialog box to delete selected cells. Ctrl+Minus (-)
Enter the current time. Ctrl+Shift+colon (:)
Enter the current date. Ctrl+semi-colon (;)
Switch between displaying cell values or formulas in the worksheet. Ctrl+grave accent (`)
Copy a formula from the cell above the active cell into the cell or the Formula Bar. Ctrl+apostrophe (‘)
Cut out the selected cells. To be able to paste in a new location. Ctrl+X
Copy the selected cells. Ctrl+C
Paste content at the insertion point, replacing any selection. Ctrl+V
Open the Paste Special dialog box. Ctrl+Alt+V
Italicize text or remove italic formatting. Ctrl+I or Ctrl+3
Bold text or remove bold formatting. Ctrl+B or Ctrl+2
Underline text or remove underline. Ctrl+U or Ctrl+4
Apply or remove strikethrough formatting. Ctrl+5
Switch between hiding objects, displaying objects, and displaying placeholders for objects. Ctrl+6
Apply an outline border to the selected cells. Ctrl+Shift+ampersand (&)
Remove the outline border from the selected cells. Ctrl+Shift+underline (_)
Display or hide the outline symbols. Ctrl+8
Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Ctrl+D
Apply the General number format. Ctrl+Shift+tilde (~)
Apply the Currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+dollar sign ($)
Apply the Percentage format with no decimal places. Ctrl+Shift+percent (%)
Apply the Scientific number format with two decimal places. Ctrl+Shift+caret (^)
Apply the Date format with the day, month, and year. Ctrl+Shift+number sign (#)
Apply the Time format with the hour and minute, and AM or PM. Ctrl+Shift+at sign (@)
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Ctrl+Shift+exclamation point (!)
Open the Insert hyperlink dialog. Ctrl+K
Check spelling in the active worksheet or selected range. F7
Display the Quick Analysis options for selected cells that contain data. Ctrl+Q
Display the Create Table dialog box. Ctrl+L or Ctrl+T

 

Post Comment