Not sure when this change happened but it is now much easier to unhide multiple sheets in Excel. In the past you had to use tick boxes to select sheets unhide. On click per sheet. Now you can just use the Ctrl or Shift keys to select multiple sheets to unhide. In the image below you can see that the tick boxes have been removed and just the sheet names are listed. You can hold the Ctrl key down to…
In the previous post I showed how to use XLOOKUP to do a two-column lookup. See the link below for the previous post. This time we will see how to do the two column lookup using Power Query.
(more…)
It is common to perform a lookup based on one column. Performing a lookup based on two columns is more unusual. This is a formula technique you can use to perform a two-column look up.
(more…)Did you know you can right click the Excel icon on the task pane? When you do you can see a list of recent files. In the image below I have right clicked the Excel icon. You can then click one of the file names to open Excel and the file. If Excel is already open it still works. You can open a recent file quickly by right clicking the icon and clicking the name. This technique also works for…