PDA

View Full Version : [SOLVED] Remove excess cells



pr1asd
12-07-2018, 07:36 AM
Dear All,

Apologies for the new thread, I was not sure what to search under. Please point me in the right direction.

The below screen shoot (sorry cannot include original as it includes sensitive information) shows that the column letters stop at L. I cannot move the selected cell any further right then this column.

How is this done?

23364

Thanks

Aman

Paul_Hossler
12-07-2018, 05:26 PM
1. Click the little area above the "1" for row number and left of "A" for column letter

2. Right click any column header A - L, not in any row cells

3. Select "Unhide" from the menu

23368

pr1asd
12-10-2018, 06:37 AM
Hi Paul,

Thank you for the information.

I assume to hide the "unwanted" columns I would select column M Ctrl+Shift and Right arrow to highlight the rest and then right click hide???

Aman

Paul_Hossler
12-10-2018, 10:28 AM
I usually would select the "M" column header, and then hold Shift, End, Right Arrow, Release Shift (but that's just habit)

pr1asd
12-13-2018, 02:02 AM
Thank you, Paul.

I feel so stupid because it is so obvious!!!

Paul_Hossler
12-13-2018, 06:12 AM
Not obvious

There are many places on the Excel landscape that will do something with a click or right click