Why three sheets?

Hmmm if I recall correctly works doesn't allow more than one sheet to a file.

I think you're right although like most other people I've only ever opened the app out of curiosity and then pulled the plug out of the socket in horror.

I seem to remember the first time I say Excel it opened with a shed load of sheets. I didn't know what a spreadsheet was then so it just puzzled me why you needed more than one page of empty boxes that seemed to do not a great deal.

One of the girls in my office still writes letters in Excel because she only ever used the Works before and can't get her head around Word and Excel not being one integrated application like Works (we don't give her anything very complex to do).
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
I agree with Gerald and also have mine set to one.

At least things have improved... My recollection is that some years ago (Excel 97??), the default was 16! Boy, did we have a lot of empty sheets hanging around wasting space then. :eek2:

I use BOOK.XLT and that seems to supercede the default worksheets setting. I suppose it depends on what you are doing. In my instance I am typically building new reporting models, so I have 6 default sheets, each named appropiately. My typical structure resembles: Index (for user navigation), Audit (notes to make it easier to audit, such as a list of named ranges etc.), Summary (because I tend to have summarised data tables), Charts, Data (because I like to keep my raw data seperate (often embedded queries for instance), Maps (lookup tables etc.).

I recommend BOOK.XLT to everyone because you can set-up so many great preferences (styles, regular names such as BigNum, BigText, some regular macro's, some page setup preferences such as headers and footers etc).

I also have a collection of macro's in my own addin, so if I want a quick and dirty 1 sheeter then that option is available to me too.
 
Just as an FYI, Book.xlt works if you use Ctrl+N or the File->New button. If you use File->New... and choose New blank workbook, your template is ignored. Go figure!
 
Now that is bizarre. Just goes to show that I never use File > New
 
I so never use File > New that it took me a couple of minutes to actually get a new file, because I didn't notice the popup thing it put at the right hand side of the screen to ask me exactly what I wanted to do...
 
I so never use File > New that it took me a couple of minutes to actually get a new file, because I didn't notice the popup thing it put at the right hand side of the screen to ask me exactly what I wanted to do...

You know I don't think I've ever seen that :oops:

When we were on 2000 is used to take an absolute age for the select what type of thingy you want window to open so I used to avoid using File...New... like the plague and have never got out of the habit.
 
Anyone remember what Lotus 123, or Quatro-Pro opened with? Some of you are bound to be old enough to remember those antiques. My boss still begins his formulas with +.

Just a digression below. I thought the original question was going to be the origin of how drunk a person is in "3 sheets to the wind."

Three sheets to the wind

Meaning

Very drunk.

Origin

Our colleagues at CANOE, the Committee to Ascribe a Nautical Origin to Everything, have been hard at work and, to their great pleasure, they can add this phrase to their list. 'Three sheets to the wind' is indeed a seafaring expression.

To understand this phrase we need to enter the arcane world of nautical terminology. Sailors' language is, unsurprisingly, all at sea and many supposed derivations have to go by the board. Don't be taken aback to hear that sheets aren't sails, as landlubbers might expect, but ropes (or occasionally, chains). These are fixed to the lower corners of sails, to hold them in place. If three sheets are loose and blowing about in the wind then the sails will flap and the boat will lurch about like a drunken sailor.

The phrase is these days more often given as 'three sheets to the wind', rather than the original 'three sheets in the wind'. The earliest printed citation that I can find is in Pierce Egan's Real Life in London, 1821:

"Old Wax and Bristles is about three sheets in the wind."

Sailors at that time had a sliding scale of drunkenness; three sheets was the falling over stage; tipsy was just 'one sheet in the wind', or 'a sheet in the wind's eye'. An example appears in the novel The Fisher's Daughter, by Catherine Ward, 1824:

"Wolf replenished his glass at the request of Mr. Blust, who, instead of being one sheet in the wind, was likely to get to three before he took his departure."

three sheets to the windRobert Louis Stevenson was as instrumental in inventing the imagery of 'yo ho ho and a bottle of rum' piracy as his countryman and contemporary Sir Walter Scott was in inventing the tartan and shortbread 'Bonnie Scotland'. Stevenson used the 'tipsy' version of the phrase in Treasure Island, 1883 - the book that gave us 'X marks the spot', 'shiver me timbers' and the archetypal one-legged, parrot-carrying pirate, Long John Silver. He gave Silver the line:

"Maybe you think we were all a sheet in the wind's eye. But I'll tell you I was sober; "
 
Nice one, Longnose.

In the case of this thread, could we then say Microsoft was three sheets to the Windows?
 

Forum statistics

Threads
1,222,653
Messages
6,167,367
Members
452,111
Latest member
NyVmex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top