• IrateAnteater@sh.itjust.works
    link
    fedilink
    arrow-up
    94
    ·
    edit-2
    12 hours ago

    Just tested. It’s Ctrl+right, not Ctrl+left.

    Edit: also, no-one says that the cell size has to remain default. 34 million pages is rookie numbers.

    • Godort@lemmy.ca
      link
      fedilink
      arrow-up
      34
      ·
      11 hours ago

      Rather than changing the cell size, just send 3 or 4 copies to the printer. Way faster

      • taiyang@lemmy.world
        link
        fedilink
        arrow-up
        8
        ·
        9 hours ago

        It’d have to be a bit more than 3 or 4 since you’re likely increasing exponentially by increasing the size and cells can get big.

        • brown567@sh.itjust.works
          link
          fedilink
          arrow-up
          16
          arrow-down
          1
          ·
          9 hours ago

          No, an increase in cell size would increase page count multiplicatively. Cells twice as tall would print the same amount as printing twice

    • I2jgwh0hYtxrCZQ@lemmy.sdf.org
      link
      fedilink
      arrow-up
      7
      ·
      edit-2
      6 hours ago

      But won’t excel detect there’s no values and no print anything?

      I think it has logic to only print pages which have values.

      1. Type “.” In A1

      2. Change the fill colour of A1 to Black

      3. [CTRL] + [A] (Selects all cells)

      4. [CTRL] + [R] (Copy’s the left most selected column across to the right most select column)

      5. [CTRL] + [D] (Copy’s the top most selected column down to the bottom most select column)

      Every cell will now contain the value “.” and be set to fill colour black.

      1. Right click any of the column letters at the top > Set width > 1000. (Changes the column width to 1000 pixels. (Expanding the cells so they take up more room when printing)

      2. Right click any of the row numbers at the left hand side > Set height > 1000. (Changes the row height to 1000 pixels. (Expanding the cells so they take up more room when printing)

      3. [CTRL] + [P] (Opens up the print dialog)

      4. [ENTER] (Selects the print button to start printing)