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 MoreBlog
Tips, tricks, and tutorials to help you master Excel and Google Sheets. Learn from our experts and take your spreadsheet skills to the next level.
Excel Shortcut: Activate Access key
About 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 MoreExcel Shortcut: Activate or Open Selected Control
About 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 MoreExcel Shortcut: Confirm Control Change
About 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 MoreExcel Shortcut: Get Help on Selected Control
About 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 MoreExcel Shortcut: Drag and cut
About 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 MoreExcel Shortcut: Drag and Copy
About 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 MoreExcel Shortcut: Drag and Insert
About 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 MoreExcel Shortcut: Drag and Insert Copy
About 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 MoreExcel Shortcut: Drag to Worksheet
About 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