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. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


 

Make Excel columns same widths across sheets

If you need to make Excel columns the same widths across sheets easily (shortcut) then you can make use of the Copy Paste feature. As shown below we want these 2 sheets to have the same column widths especially in columns E,F and G which we want to be very narrow.

Make Excel columns same widths

YouTube Make columns the same widths across sheets

Copy an example row with the widths you want

To do this you need to either go to each column manually and make the columns the same, or the better way is to go to a sheet with the column widths you want (1 below), and copy the cells.

Then on the other sheet click in the start cell and go to the HOME ribbon (2), Paste dropdown (3), and choose Paste Special (4).

Make Excel columns same widths

Paste only the Column Widths, nothing else

Now you can choose to paste ONLY the column Widths as shown below. If you do it this way it ignores what was in the copied cells and only copies the column widths.

Make Excel columns same widths

Make the cursor start on the same cell in each sheet