Forum Discussion
Creating Pagination in Excel
Hello,
in Excel 2013 and 2016 you can do this with a table and Table Slicers. You will need a helper column that calculates the page number for each item. Consider the following screenshot:
The page number is calculated with the formula
=CEILING((ROW()-1)/$F$2,1)
Starting in row 2 and copied down. Now you can insert a slicer (table slicers only exist in Excel 2013 and higher), set it to have a few columns (I selected 5), and then click the slicer to show only the data on that page.
You can change the number of items that show on a page by adjusting the value in cell F2.
Hello,
in Excel 2013 and 2016 you can do this with a table and Table Slicers. You will need a helper column that calculates the page number for each item. Consider the following screenshot:
The page number is calculated with the formula
=CEILING((ROW()-1)/$F$2,1)
Starting in row 2 and copied down. Now you can insert a slicer (table slicers only exist in Excel 2013 and higher), set it to have a few columns (I selected 5), and then click the slicer to show only the data on that page.
You can change the number of items that show on a page by adjusting the value in cell F2.
Hi Ingeborg Hawighorst,
Thanks for your support and i have tried the way what you suggested.Im using office 2013 and luckily it has the same featute (Table Slicers).
Thansk a lot again.
Regards,
Chelvan
Yes, that's right. I just checked my notes. Slicers for Excel tables were introduced with Excel 2013.