-1

I've made a simple sheet to generate a random list of words to be printed. I don't know why but even if I've made the formula to check the number of words in column A of "lista" tab, on the print tab, it continue to generate white cells and so, when I press print, it want to print 22 pages (20 empty). Could you help me to limit this to just the pages needed to print the available words generated in the print tab?

https://docs.google.com/spreadsheets/d/1Jb66PhYPsegNJYpzwrYIArLp0vTBjMtaNOqNf-qSrdA/edit#gid=0

  • Add the formula to the question – Rubén Nov 21 '19 at 1:51
0

Delete the blank rows on your print page. Your data ends at row 71 but you have a bunch of blank rows underneath and you are wondering why it wants to print blank pages?

| improve this answer | |
  • I know, and I've deleted them, but after few seconds they appear again even if I'm using a cell to count the number of items, that's why I'm asking... – Simone Rosmarino Nov 21 '19 at 8:27
  • @SimoneRosmarino give me the steps to make it appear, I deleted them, and they are not reappearing for me. – CodeCamper Nov 21 '19 at 16:36
  • what did u deleted exactly? Cells or their content? Cos I wanna keep the cells but empty, and it should preview me to print only the area with text normally. For example, if I copy the pure text in a new sheet, it prompted to print exactly just it, but in the "print" tab, it ask me to print 22 pages (blank cells). I went to those went cell, hit backspace to delete, gsheet recognize them as empty but still wanna print 22 pages...I dont wanna delete the rows cos I wanna keep the grid formatted in my way for new data entries basically – Simone Rosmarino Nov 21 '19 at 17:23
  • @SimoneRosmarino I click on all the blank rows on the bottom and I right click and press delete rows. – CodeCamper Nov 21 '19 at 17:31
  • But I wanna have that format for any new lines, how could I do it otherwise? – Simone Rosmarino Nov 22 '19 at 9:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.