In my old version of Numbers, I could see the page break (both at the bottom of the page, and on the side) so I would know when I needed to add a row or column. I can't seem to be able to see the page break anymore: I need to go to print preview in order to get a sense of where rows and columns are on the page.
Is there a way to see the page break in the new version?
How to see page breaks in Numbers version 3.x
numbers
Related Solutions
I'm using Numbers 3.5 on Yosemite. In this version I can click the tiny arrow on the row number (e.g.. 1-20) or the column letter (e.g.. A-P) and this yields a menu (hover the row number or column letter to see the small arrow). The choices "Hide row" and "Hide column" are in those respective menus.
According to your description, it appears that these "hide" features have been moved to their respective row/column header menus.
So, this is easy to solve in Excel... I don't have access to Numbers at the moment, but I'll give you the solution I'm aware of and you can confirm whether it works in Numbers like it does Excel.
You can create a column with the following formula:
=Row() - 1
This will always give you one less than the "default" row number, which is what you are looking for. It also won't be affected by sorting.
A complete reference of functions that are available in Numbers can be found HERE, including the ROW function.
Related Question
- When using Numbers app, is there a setting to create a new column when user presses tab
- Numbers: Find a cell in a table (lookup) using multiple criteria
- (Numbers) COUNTIF values from one column match another column
- MacOS – How to print one Numbers row per page, formatted nicely
- How to add all of the text strings in all of the cells in a row together
- Mac Numbers: How to identify cells that match a range of cells from another table
- Numbers: Possible to transpose Rows and Columns during Import of txt file
Best Answer
Unfortunately, Apple's Numbers has never had page breaks. Here is a solution created from Yellowbox on the Apple's Community forum: https://discussions.apple.com/docs/DOC-7101.
Here is also a answer from Ian, also on Apple's forums--
"Numbers has never had Page Breaks.
If you are using Numbers '09 it has Show Print View which is useful for arranging (and resizing) objects on pages before you print to paper.
If you are using Numbers 3, there is only Menu > Print > Print Preview (Print Setup) which shows the pages, but is not editable."