Hiding rows if they are empty using formulae

B

bill070860@hotm

I have a spreadsheet with various calculations and links, however i nee
to eliminate any rows that are empty, in order to utilise the space o
the page so that other information can be displayed.
For example if, row empty then hide and go to the next row etc until
row is reached with info in it then it can be displayed. Th
information on the page changes all the time, so this would be a ver
flexible way of utilising the page free space. not just for the peolp
who are using it but for me, for printing the information, keeping i
all on one A4 page if it is possable.
I know that you can do it with shortcut keys but i would like to past
the formulae in the apropriate cell for that row.

Any help would be greatfully appreciated.

regard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top