In this post, I describe how to add a filter to more than one column in Microsoft Excel. If you just select one column then press Filter , Excel will only apply a filter to that column: Resolution To apply a filter to more than one column: 1. Ensure there is no filter currently applied and that only a single cell is selected: 2. Go to the Data tab on the ribbon then press the Filter button.  A filter is then added to every column: 3. Use the drop down arrows to apply a filter to each column:

 In this post, I describe how to open a Microsoft Excel Worksheet as read only. This can be useful if you want to open a Microsoft Excel Worksheet on a shared folder without preventing another user from being able to edit the same spreadsheet. I'm using Windows 10 and Microsoft Excel 2019. Resolution To open a Microsoft Excel spreadsheet as read only, in Windows Explorer, hold the SHIFT key on the keyboard then right click the xlsx file to reveal some additional options: On my computer,  Open as Read-only  did  not  open the Worksheet as read only. However,  Open in Protected View  allows you to view the spreadsheet whilst also enabling another user to edit that spreadsheet. Open Read-Only You can force Excel to open a Worksheet as read only by: 1. Open Microsoft Excel. 2. Go to  Open  then  Browse . 3. Navigate to the Worksheet you want to open,  single click  the file to select it then click the down arrow to the right o...

Issue When importing a CSV file into Microsoft Excel, you may find that it is not using "Use First Row as Headers" so you end up with Column1, Column2 etc as headers. Resolution To resolve this issue, press the Transform Data button in the bottom right. This loads the Power Query Editor which includes the "Use First Row as Headers" option in the Home ribbon.  Press this option once. Press Close & Load to apply. The first row is now being used as headers: Related Posts - Open a Microsoft Excel spreadsheet xlsx file as read only