Forum Discussion
Creating Pagination in Excel
Hi ,
Anyone can suggest me how to add paggination in excel
in my case i would like 10 rcords each view and by using pagination i can view the balance
So please suggest me is there any way to do this ???
Thanks in Advance
Regards,
Chelvan
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.
3 Replies
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.
