Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default How can I know the size of each sheet

Hi to all;

I'm new in this forum.

I use excel usually at work and I need to know how could I know the size of
each sheet.

Thanks to all;
--
atrep
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default How can I know the size of each sheet

What do you mean by size:

Prior to XL2007, 256 columns and 65536 rows.

"xavi garriga" wrote:

Hi to all;

I'm new in this forum.

I use excel usually at work and I need to know how could I know the size of
each sheet.

Thanks to all;
--
atrep

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default How can I know the size of each sheet

Sorry I didn't specify my question enough, with size I mean "memory" (bytes).

Thanks
--
atrep


"Toppers" wrote:

What do you mean by size:

Prior to XL2007, 256 columns and 65536 rows.

"xavi garriga" wrote:

Hi to all;

I'm new in this forum.

I use excel usually at work and I need to know how could I know the size of
each sheet.

Thanks to all;
--
atrep

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How can I know the size of each sheet

Just a general "feel" for relative size:

Save each sheet as a new workbook.
Open explorer and look at the sizes.

There's overhead for each workbook (varies depending on the version of excel),
but you could just save a workbook with a single empty worksheet to see that
overhead.



xavi garriga wrote:

Sorry I didn't specify my question enough, with size I mean "memory" (bytes).

Thanks
--
atrep

"Toppers" wrote:

What do you mean by size:

Prior to XL2007, 256 columns and 65536 rows.

"xavi garriga" wrote:

Hi to all;

I'm new in this forum.

I use excel usually at work and I need to know how could I know the size of
each sheet.

Thanks to all;
--
atrep


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default How can I know the size of each sheet

Thanks,

I thought about this option, but I didn't do because there are lots of links
between sheets and I didn't know if it would affect a lot. However, I'll do
this solution.
--
atrep


"Dave Peterson" wrote:

Just a general "feel" for relative size:

Save each sheet as a new workbook.
Open explorer and look at the sizes.

There's overhead for each workbook (varies depending on the version of excel),
but you could just save a workbook with a single empty worksheet to see that
overhead.



xavi garriga wrote:

Sorry I didn't specify my question enough, with size I mean "memory" (bytes).

Thanks
--
atrep

"Toppers" wrote:

What do you mean by size:

Prior to XL2007, 256 columns and 65536 rows.

"xavi garriga" wrote:

Hi to all;

I'm new in this forum.

I use excel usually at work and I need to know how could I know the size of
each sheet.

Thanks to all;
--
atrep


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY? Jerry Excel Discussion (Misc queries) 0 June 1st 07 05:06 PM
Work sheet size relative to screen size Florida Tom Excel Discussion (Misc queries) 1 April 16th 07 02:22 AM
how to set sheet size to reduce file size LJ Excel Discussion (Misc queries) 1 November 26th 06 02:35 AM
Size of each sheet Brisbane Rob Excel Discussion (Misc queries) 3 February 20th 06 07:50 PM
SIZE OF SHEET Rueben Excel Discussion (Misc queries) 1 May 20th 05 10:02 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"