Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


Excel scroll bars not working

If you are trying to go down or across on a spreadsheet using the scroll bars and the sheet is not moving it could be a problem with frozen panes. So if it looks like the Excel scroll bars are not working and the spreadsheet is not moving down with your mouse then this may be the problem.

YouTube Excel Scroll bars not working

Freeze Panes affects scroll bars

As shown below, check if you have Freeze Panes on. Depending how you put them on, the frozen section of the screen may be too big and covering the whole screen so you don’t see the movement.

Excel scroll bars not working

Make the cursor start on the same cell in each sheet

Unhide rows not working in Excel

Remove extra scroll bars in Excel