Ticker

6/recent/ticker-posts

Ad Code

Responsive Advertisement

70+ Excel Keyboard Shortcuts for Windows

Microsoft has some amazing tools to help improve your productivity. Excel is one of the best when it comes to handling office work. However, there are ways to improve your work in Excel and speed up your work even more. You can use these shortcuts to do just about anything - from formulating rows and columns to organizing and formatting your work. Read on to learn more about these shortcuts and take your excel skills to the next level.

Excel Shortcuts

Action Shortcut
General
Creating a brand new workbook Ctrl + N
Saving an existing workbook Ctrl + S
Opening the print menu Ctrl + P
Opening various Excel options Alt, F, T
Opening the right-click menu options Shift + F10
Protecting or unprotecting a workbook Alt, R, P, W
Protecting or unprotecting a worksheet Alt, R, P, S
Input and Editing
Copying data Ctrl + C
Cutting data Ctrl + X
Pasting data Ctrl + V
Opening the paste special window Ctrl + Alt + V
Undoing the last few actions Ctrl + Z
Redoing the last few actions Ctrl + Y
Copying data and formatting from the cell above Ctrl + D
Using Flash Fill Ctrl + E
Inserting the current date Ctrl + ; (Semicolon)
Inserting the current time Ctrl + Shift + : (Colon)
Navigation and Selection
Moving to a cell Arrow key
Moving to the very first cell Ctrl + Home
Moving to the last cell of the right column Ctrl + End
Moving to the very first cell in the current row Home
Moving to the edge cell within a specific region Ctrl + Arrow key
Moving one screen up or down Page up/down
Moving one screen right or left Alt + Page down/up
Moving to the next or previous sheet Ctrl + Page down/up
Selecting a cell in the chosen direction Shift + Arrow key
Selecting one screen right or left Shift + Alt + Page down/up
Selecting a row Shift + Space
Selecting a column Ctrl + Space
Selecting additional rows, columns, or cells Ctrl + Left click
Selecting the entire active worksheet Ctrl + A
Toggling the Ribbon shortcuts Alt
Navigating the Ribbon sections Alt, Arrow key
Opening the Find and Replace window Ctrl + F
Zooming in Ctrl + Alt + = (Equals)
Zooming out Ctrl + Alt + - (Minus)
Visibility and Grouping
Hiding a row Ctrl + 9
Hiding a column Ctrl + 0
Opening Group window functions Shift + Alt + Right arrow
Opening Ungroup window functions Shift + Alt + Left arrow
Tables and Graphs
Creating a table Ctrl + T
Opening the table styles window Alt, H, T
Inserting a row above Alt, H, I, R
Inserting a column to the left Alt, H, I, C
Opening the PivotTable menu Alt, N, V
Opening the PivotTable wizard Alt, D, P
Formatting
Opening the Format Cells window Ctrl + 1
Applying the General number format Ctrl + Shift + ~ (Tilde)
Applying the Currency format Ctrl + Shift + $ (Dollar)
Applying the Percentage format Ctrl + Shift + % (Percent)
Applying the Scientific format Ctrl + Shift + ^ (Caret)
Applying the Date format Ctrl + Shift + # (Hash)
Applying the Time format Ctrl + Shift + @ (At)
Applying or removing bold Ctrl + B
Applying or removing italic Ctrl + I
Applying the left align Alt, H, A, L
Applying the center align Alt, H, A, C
Applying the right align Alt, H, A, R
Adjusting the row height Alt, H, O, H
Adjusting the column width Alt, H, O, W
Applying the bottom border Alt, H, B, O
Applying the top border Alt, H, B, P
Applying the left border Alt, H, B, L
Applying the right border Alt, H, B, R
Applying all borders Ctrl + Shift + & (Ampersand)
Removing all borders on selected cells Ctrl + Shift + _ (Underscore)
Opening the border menu Alt, H, B
Inserting a note Shift + F2
Formulas and Macros
Inserting the AutoSum formula Alt + = (Equal)
Expanding or collapsing the formula bar Ctrl + Shift + U
Opening the Insert function window Shift + F3
Opening the Visual Basic editor Alt + F11
Opening the Macro window Alt + F8

Excel At Excel

And there you have it - excellent shortcuts to take your excel productivity to the next level. You can pair these shortcuts with other productivity tools to finish your work faster.

Thank you for being a Ghacks reader. The post 70+ Excel Keyboard Shortcuts for Windows appeared first on gHacks Technology News.

Enregistrer un commentaire

0 Commentaires