Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: October 2012

Printing: Making it look like a spreadsheet

October 28, 2012 gexner

Up till now I’ve been talking about printing out tables, and usually most people don’t care what sort of program generated the table. It should look clean, it should not have a lot of extraneous information, and it should only… Read morePrinting: Making it look like a spreadsheet

Printing: Print order

October 21, 2012 gexner

The printing options and tricks I’ve discused over the last group of posts are definitely not all the options available — they’re just the ones I use on a regular basis. However, spreadsheets have a number of other printing quirks… Read morePrinting: Print order

Creating auto-updating tables

October 14, 2012 gexner

The last thing I mentioned on my post about printing was creating automatically updating duplicates of your tables. Sometimes, when I’m working with a lot of data and doing a lot of synthesizing, I want to make a table on… Read moreCreating auto-updating tables

Printing: Printing only part of the sheet

October 7, 2012 gexner

One of the things I do in my regular job involves generating statistics to go in tables to go in reports. Quite frequently I end up doing multiple layers of synthesis: I’ll do one, then use the results of that… Read morePrinting: Printing only part of the sheet

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top