Excel tips and tricks

Things to Remember Borders can be used with the shortcut key Alt + H + B, which will directly take us to the Border option. Giving a border in any data table is very important. ... Always make proper alignment so that once we frame the data with a border and use it in different sources, the column width will be automatically set. Ctrl+; – Inserts the date. Ctrl+Shift+: – Inserts the current time. Ctrl+0 – Hides the selected column. Ctrl+9 – Hides the selected row. Ctrl+` – Reveals all of the formulas embedded in your spreadsheet. Ctrl+PageUp or PageDown – Toggles between sheets in the currently open workbook. F2 – Start editing the current selected cell vs. double clicking. Shift+F10 – Opens the right-click menu for the selected cell.