Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Sheet size (MB)?

Is there a simple way of seeing how much space (in MB) each sheet is taking up in am Excel Workbook?


Post your answer or comment

comments powered by Disqus
I cannot even get my head round this one.

I have a list of sheet sizes

140x90
160x100
160x70
170x140
170x90
180x100
180x110
180x120
180x70
180x80
190x100
190x130
190x140
190x80
190x90
200x100
200x110
200x120
200x80
210x100
210x130
210x150
210x80
220x100
220x110
220x130

this is only a sample, I currently have 600 sizes of sheets

which I have to optimise into a fixed range of sizes.

Has anyone ever tried this or have any idea of how to do it ?

I need to be able to say I want 5 sizes and it tells me what sizes are best for this range ?

Hi,
I would like to be able to customise the sheet size in Excel, so that when
anyone opens up this specific file they only see the part of the sheet I want
them to. Basically I want to eliminate all the "space" in the sheet that Im
not using. So, if Im only using rows and columns C to 4, that is all anyone
sees when they open the file.
Hope someone can help.
Thanks

I need to reduce the sheet size so that the size of the file is also reduced

Hi,
I would like to be able to customise the sheet size in Excel, so that when
anyone opens up this specific file they only see the part of the sheet I want
them to. Basically I want to eliminate all the "space" in the sheet that Im
not using. So, if Im only using rows and columns C to 4, that is all anyone
sees when they open the file.
Hope someone can help.
Thanks

I have some code part of which copies rows of data to a sheet, formats it (column widths) then copies the whole sheet to a new workbook then clears the sheet using:
this code can be looped through many times, however each time it loops the sheet size increases by over 200K so after 20 or
more loops I end up with a file size over 5MB. I know the file size is because of this sheet because I can delete it as a
check. I attach a copy of a sample sheet which has a single empty sheet yet has a file size of over 200K,.
Can anyone tell me what is on this sheet that I am missing and what code I can use to clear it. As a workaround I can delete the sheet and then add it back on again at each loop but this seems inefficient and I also have a company logo in the top corner so using this workaround means I have to copy the logo each time as well.

Sorry I cant attach the code because it is very large and has many company references within so I have paired it down to a single blank sheet

How can I set the sheet size to, say, 40 cols x 60 rows? Tried setting all
other col's to 0 width but panning still brings me into the uncharted grey
region where they used to be.

Thanks,

rs

Is there any way of finding out the mb size of individual sheets within a
workbook. I can only view the size of the file as a whole by going to File
and then Properties and General

Thanks,

Esther

Hi,

I'm trying to become more efficient and avoid loops where I can.

I deal with sheets of various sizes, and my macro just counts the number of rows (which are usually 20,000+) by using COUNTA in the index column, and loops that many times.... replacing blanks with "."

Is there a better way to do this... by using the COUNTA command to tell excel the range of cells with data in it?

Your help would be much appreciated.

Is there a way to restrict your excel sheet size to a specific set of cells... so when you open the excel file, you only see that limit, rather then a sheet filling the entire screen.

I want to calculate how many bytes in one sheet, the size of a excel
file(in bytes)
Is there any functions to get them?
Thanks

---
Message posted from http://www.ExcelForum.com/

I am working in Excel 2007 (beta)
I have created my sheet and was able to remove sheets 2 & 3 which I don't
need.
I would like to trim the size of the sheet and only print the contents of my
data but do not know how to remove the excess columns/rows which mae up a
full Excel sheet.
Is there a way of saving my sheet with only the cells I have data in
compacting my sheet for future reference without the extra cells?

1. I have a workbook with 42 sheets. Size: 3,8 mb
2. Then I have a copy with a diagram on each sheet. Size:
43,5 mb (approx. 1 mb per diagram).
3. Using a macro I copy the diagrams (diagrams only) to a
new workbook. Size: 132,6 mb !!!

If I copy the 42 diagrams manually, the size of the new
workbook is only 24,5 mb.

Can anyone explain this mystery? Any ideas as how to copy
the diagrams automatically and keep the file size down to
"normal"?

Thanks,

Eric Bentzen

Hi, is there a way to find out the size of each sheet in a workbook?
Thank's ahead

Hi
We are currently planning to create some reports and before we start on it
we would like to know if excel has any limits on the number of work sheets.
We hope to join a number of our current reporting files into one.
We are looking are having approx 100 pages. 63 with charts, 10 with a
dashboard look and the remaining 27 with data.
I think the sheets issues will be fine, not sure if the size *(MB) will
cause issues.

Thanks in advance.

I am working in Excel 2007 (beta)
I have created my sheet and was able to remove sheets 2 & 3 which I don't
need.
I would like to trim the size of the sheet and only print the contents of my
data but do not know how to remove the excess columns/rows which mae up a
full Excel sheet.
Is there a way of saving my sheet with only the cells I have data in
compacting my sheet for future reference without the extra cells?

I have a 5MB excel file and it contains 6 worsheets. How can I find the size of each sheets or what is the contribution of each sheets in file size?
Is there a way?
Thanks
Itty

I think I've finally got the rest of my errors and breaks handled, but I just can't figure this one out. I'm giving my users a workbook containing updated code and forms; this will be used to update the workbooks they are already using. Corporate security prevents me from accessing and writing to the VB Project, so the best I can do is give them this workbook which will pull in (copy) their data sheets and fix some formulas, leaving them with the same data and worksheets on top of new and improved code and forms.

Here's how it works:

-- User clicks a cell, which triggers a Selection_Change event, which calls my main macro
-- The main workbook copies itself; this copy will be the “base” of the improvements
-- OPEN dialog is used to gather names of files to be fixed; these are written into the main workbook
-- Iterate through list of files and open, copy worksheets, fix stuff, save, and close

It all works, for the most part. But if it’s gonna break, it will be in the action to copy the sheets over. If I F8 or F5, it runs fine. But If I start from clicking the cell like my users will, there’s a good chance it will break.

The break always happens after copying the first sheet. The sheet is copied - and the code simply stops. Even when I wasn’t trying to suppress alerts and such, it would just stop dead. I’ve got a log file running to record events, and the log file statement never gets run. But the sheet is copied.

The sheets being copied do contain formulas and named ranged. Before I added Application.EnableCancelKey = xlDisabled, I'd always get alerts asking me if I wanted to keep or replace the names.

Any hints on overcoming this are greatly appreciated!
Ed


	VB:
	
 the correct item[/SIZE][/FONT] 
[FONT=Times New Roman][SIZE=3]Sub CopySheetsOver()[/SIZE][/FONT] 
 
[FONT=Times New Roman][SIZE=3] 'Copy every sheet[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]For Each wks1 In wkbTracker.Worksheets[/SIZE][/FONT] 
[SIZE=3][FONT=Times New Roman]  If wks1.Name  "FAQs" Then[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    Call RmvProt[/FONT][/SIZE] 
 
[SIZE=3][FONT=Times New Roman]    a = wkbNew.Worksheets.Count[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    DoEvents[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    Application.DisplayAlerts = False[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    Application.EnableCancelKey = xlDisabled[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    wks1.Copy After:=wkbNew.Sheets(a)[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    DoEvents[/FONT][/SIZE] 
 '''~~The next line is not run~~
[FONT=Times New Roman][SIZE=3] '**********************[/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3]LogInformation ("Copied over " & wks1.Name)[/SIZE][/FONT] 
[FONT=Times New Roman][SIZE=3] '**********************[/SIZE][/FONT]
 
[SIZE=3][FONT=Times New Roman]    Application.EnableCancelKey = xlInterrupt[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]    Application.DisplayAlerts = True[/FONT][/SIZE] 
[SIZE=3][FONT=Times New Roman]  End If[/FONT][/SIZE] 
[FONT=Times New Roman][SIZE=3]Next wks1[/SIZE][/FONT] 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hello,

What I need is simple(I hope ), I need to find out where the actual data is in a sheet,
so if e.g. there is only data is between C5 and H10 and everything else is
empty in the current sheet then the macro has to find exactly those rows
and cols. Additionally, the data in a single row or column can be
discontinuous.

alot in advance!

Good morning all,

This question may be very simplistic to you, but here it goes.

I received a spreadsheet from a co-worker yesterday with something I never seen before. The sheet was a simple monthly work day schedule, but what I noticed was that only the cells used to define the area were visible/accessible the others not.
Here is what it contained: a column for each day of august and a row for each department member. There was a thick border around the cell grouping and the outside cells not accessible.

Can someone tell/point me in the way to learn how to do this?

Thanks

How can I change the default setting for "zoom" from 100% to 75%. So that
when I open a new excel sheet, it is already set to 75%

Thanks
Glen

My worksheet is only about 1/4 the size of display screen. Above the column
headings is a 1 and a 2 vertically arranged.
How do I enlarge the worksheet to fit the screen?

Thankyou

I have a spread sheet that tracks outages by pulling information from other spread sheets that is tracked on a daily bases. It is a 34 kilobyte sheet, but when it is e-mailed to anyone it shows up as a 2 meg file. I can not figure out why, has anyone had this issue? Can it be something in the way I have the spread sheets formulated to where it is sending all the spread sheets it pulls its information from?

Thanks

I'm seeking to setup a workbook initially containing one sheet, named "PC01", that has a button macro to generate a new sheet "PC02" (of identical dimensions, layout, column headers, etc) but will take some of the previous sheet's data from one column and place in another column.

To be a little more specific here is a small example (see attached). Sheet size A1:E5. Column A has item descriptions, column B is total value, column C is "complete previous", column D is "complete to date", and column E is "complete this month". Column E is a formula, simply complete to date (D) subtract complete previous (C).

On pressing the button to create a new report for the following month, the aim is that it will:
* generate a new sheet (adding +1 to the sheet name);
* copy the 'values' from column from old sheet D (complete to date, previous month) and paste them into new sheet C (complete previous, for current month)
* maintain other data (i.e. columns A & B), and formulas (i.e. column E, and totals Row 5)

So.... where do I start?

Thank you immensely to anyone who can assist! I've been searching on and off for about a year now, with no luck, so I thought finally I should ask (as now I really need to implement this thing).

-Luke.

Hi All,

I have worksheet which designed from columns A to O and my computer’s screen set to 1024 by 768 pixels. When same sheet opens in other computer which has screen settings 1152 by 864 pixels, it shows more columns next to column O which I would not like to be visible. Is there a way or code to make sheet size standard (or something else)?

Thank you in advance


No luck finding an answer? You could always try Google.