Excel Shortcut: Expand or Collapse Ribbon
About This Shortcut Expand or Collapse Ribbon – Ctrl + F1 displays or hides the ribbon in Excel. Keybord Shortcut key Window: Ctrl + F1 Mac: Cmd + Alt +…
Read MoreTips, tricks, and tutorials to help you master Excel and Google Sheets. Learn from our experts and take your spreadsheet skills to the next level.
About This Shortcut Expand or Collapse Ribbon – Ctrl + F1 displays or hides the ribbon in Excel. Keybord Shortcut key Window: Ctrl + F1 Mac: Cmd + Alt +…
Read MoreAbout This Shortcut Activate Access keys – In Excel, Alt activates access keys. It will let you move data while still holding down the mouse key and switching between Excel…
Read MoreAbout This Shortcut Activate or Open Selected Control – When you click this, the corresponding section of the ribbon (menu or gallery) will open. Keybord Shortcut key Window: Space OR…
Read MoreAbout This Shortcut Confirm Control Change – The Enter key navigates to a command or option in the ribbon, allowing you to change it and return focus to the Microsoft…
Read MoreAbout This Shortcut Get Help on Selected Control – F1 displays help for the currently selected command. If there is no Help article linked with the specified command, the Help…
Read MoreAbout This Shortcut Drag and cut – You can move a selection by selecting the cells, holding the mouse over the selection until it changes into a four-headed arrow, then…
Read MoreAbout This Shortcut Drag and Copy – The default behaviour for drag and drop is to cut data in cells, but you can also copy cells during drag and drop.…
Read MoreAbout This Shortcut Drag and Insert – The shortcut will insert cells at the new location. Additionally, it functions when dragging complete rows or columns. Keybord Shortcut key Window: Shift…
Read MoreAbout This Shortcut Drag and Insert Copy – The shortcut keys copies values and inserts cells at the new location. It also works when dragging entire rows or columns. It…
Read MoreAbout This Shortcut Drag to Worksheet – The drag and drop feature is limited to the same worksheet. Alt + Drag is useful to move a selection to a different…
Read More