Browsing: Microsoft Excel
To group rows in Excel, select the row numbers you want to organize, open the Data tab, and click Group…
To password protect an Excel file on Windows, open your workbook and go to File > Info > Protect Workbook…
To unhide columns in Excel, select the column headers on both sides of the hidden columns, right-click, and choose Unhide.…
To make a histogram in Excel, select your numerical data, click the Insert tab, choose Insert Statistic Chart, and select…
To hide a column in Excel, click its column letter, right-click the selected header, and choose Hide. The column disappears…
To add a check box in Excel, select a cell or range, open the Insert tab, and choose Checkbox. You…
Need to switch two columns in Excel without losing your data? The safest approach is to use Cut and Insert…
To combine columns in Excel, enter =A2&” “&B2 in an empty cell and press Enter. This formula joins the values…
To disable Scroll Lock in Excel, press the Scroll Lock (ScrLk) key on your keyboard. If your keyboard doesn’t have…
If you need to combine multiple Excel files into one worksheet, Power Query is usually the best option. It can…