How to Limit View to Specific Row of Columns A-C

Question

I've seen some Excel Spreadsheets in which you can only see certain columns, for example, A-C. You can't scroll off to the right in never never land. What is this called? How can you create this? I tried to create a view and typed A1:C11, which are the cells I'm using, but I was still able to scroll over to the right.

For an example of what I'm talking about, see this picture: 

Answer 1

To Hide all columns to the right of column K:

1. Click the column heading for Column L
2. Press Shift+Command+➡︎ [to select all columns to the right]
3. Use the keyboard shortcut Control+0 [zero] or right-click any selected column & choose the Hide command

Answer 2

Hi AEW9,

You can hide the rows and columns which you don’t want to show to achieve your goal.

For example, I created a worksheet contains some data.

Firstly, select a cell out of the area contains data, and press Command + A to select all sheet, press Command + select columns contain data to exclude these columns. Then right-click the selected area and choose Hide. Columns to the right of C column will not displayed.

In the same way, you can also hide the rows.

Best regards,

Madoc

Answer 3

To:  AEW9

Re:  hiding columns

Right-click a column header (the part that contains the column letter).

From the popup menu, select "Hide".

'---

Create Custom Passwords workbook at MediaFire...

http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Answer 4

Thank you!

Answer 5

Thank you—the GIF was helpful!