Mock spreadsheet as per below.
1. I have a power query which has over 500 lines. (Column A - C)
I have set conditional formatting to highlight specific cells containing the word "CANCELLED".
The user of this report will need to scroll through 500 lines to identify any "cancelled" transactions...
Hi There. On certain workbooks, when I move the vertical scroll bar in a worksheet to move through the rows quickly, the rows do not move with the scroll bar. The same rows are shown until I release the vertical scroll bar with the mouse and then it jumps to the new rows. It must be a setting in...
Hi There. I have a very annoying problem. When I scroll in a worksheet with the vertical scroll bar, the worksheet contents do not move with the bar. Once I release the mouse click from the vertical scroll bar, the worksheet jumps to that position. I would like the worksheet to move with the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.