Computer Support Forum

Excel worksheet page length

Question: Excel worksheet page length

I have 2 Excel files that I create for my company, a list of items we sell, one with prices and one without.  I use 2 columns on a page for both of them.  Other than the prices, they are exactly the same.  However, when I print them out, the one with prices breaks one row lower than the other, even though the margins, row height, and other page setup settings are exactly the same, as well as the printer.  I would like to make them the same, as it makes it easier to copy and paste new data between them.  Any help would be most appreciated.

Relevance 100%
Preferred Solution: Excel worksheet page length

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Excel worksheet page length

A suggestion for a quick and dirty fix !  You say it is the list with the prices that is breaking one row lower. Go into 'Print preview' and 'Setup . . .' and increase the bottom margin very slightly, say by 0.1 cm. this should make it break a row earlier to match the other.
Apart from the elegance aspect, does it make a difference that it is the printed version that is showing this behaviour ?  Surely, any copying and pasting you are doing is done on screen and you imply that any misalignment is only showing up in the printed version.
Chris Cosgrove

3 more replies
Relevance 77.08%

Does anyone have any suggestions as to how I can fix this problem.  I have excel open and it seems that the actual worksheet has been minimised (even though the main excel window is maximised) and the first two columns of the worksheet (e.g columns A & B) are off the page.  Would appreciate any suggestions!  Thanks, ljc.

Answer:Excel worksheet half off page??

This is what I understand your problem is - Excel is maximized, but you have a small window inside Excel, which is your worksheet.You want the worksheet maximized.Right?If so, the small window will have close, minimize and maximize buttons, same as the main window.Press maximize, and it will go back to its full size.Does that help?

10 more replies
Relevance 75.44%

RE: Excel 2007
Worksheet page numbers are no longer at the bottom of the page.
What can I do to view them?

Answer:Excel 2007, Worksheet Page Numbers Disappeared

Hi there, welcome to the board!

What do you mean "Worksheet page numbers"? Can you describe for us what exactly which you are looking at and what view type you are in?

3 more replies
Relevance 74.62%

I have a conundrum and I hope somebody out there can understand what I am talking about. I have a spreadsheet I am developing where the first worksheet is a table of contents and summary, and I have over twenty worksheets that all contain data for different items.

I would like to be able to click on a cell within my table of contents worksheet and have the relevant worksheet open so I don't have to keep scrolling through endless sheets. I have to log a bunch of defective items and keep notes & tallies on them so if there was such a function as this it would really help me out! (I really don't want to have to do this on Word) My searches on Excel's help page have all been in vain - seems like nobody has ever asked this question (or nobody has in a way that I understand). As you can probably tell, I don't know a whole lot of technical jargon. I am a beginner at this, so please keep it simple! Thank you!!!!!

Answer:Solved: how to link an excel worksheet to a tabel of contents page?

CTRL+K is the hotkey combo for "Insert Hyperlink".

Then choose "Place in this document"; from there, it's self-explanatory.

Welcome to the board.

3 more replies
Relevance 70.52%


I need help with a formula. I need the formula to calculate totals from 10 worksheet.

Totals to come from C164 from each sheet to total in the summary worksheet D20. I can't seem to get it past the first worksheet. This is the formula that I have. The work sheet are named xx1-xx10

=Sum(xx1!c164,xx2!c164,xx3!c164,xx4!c164,xx5!c164,xx6!c164,xx7!c164,xx8!c164,xx9!c164,xx10!c164) IIs this possible?
Please and thank you!

Answer:Excel Formula using multiple worksheet to calculate into a summary worksheet.

Moving thread to the Office Forum for better results

2 more replies
Relevance 69.7%


I have one worksheet with 3 colums and rows.
I need to create a new dinamic worksheet from the data on the 1st sheet.
Columns in the 1st sheet are:

Material Plant Quantity
AAA 1 100
AAA 2 50
AAA 3 20
BBB 1 30
BBB 3 10

I know descriptions for the Plants: 1 - "East", 2 - "West", 3 - "South".
I have to create macros or formulas to build a new worksheet from information on this one. It is basically take a Material group by, then Plant and sum of Quantity for that specific Material and specific Plant , and build a column for that specific Plant, with provided description. So if its Plant =1 , then column is "East", and so on.
So, essentially the new worksheet shooud look like this.
Quantity for Materials based on Plant.

Material East West South
AAA 100 50 20
BBB 30
BBB 10

Can someone give me tips on how to build that new worksheet and how should i build macro?

Thank you,

More replies
Relevance 68.47%

Hi Wayne, I have another one...

I have two Excel Sheets. One is a list I call database with all of the information in a list. The second sheet is ?prettied up? into a the looks of a nice form (but not a form, just formatted to look nice).

I have the same column names in both locations. The list layout is landscape and the ?form? is portrait. The data in each row of the list/database is what I would like to have prepopulate into the ?form? below to print a single record, but I can?t figure out how to make this work. The data in the list will change continue to have data added at the bottom.

Answer:Excel - Prepopulating a worksheet from a worksheet list

would you change the image to an actual spreadsheet with a sample
also the image is a screen shot of the other post

1 more replies
Relevance 61.5%

I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fine until the other region updated their Excel to 2013. Now the other region is having trouble with the spreadsheet; namely the drop-down boxes are showing that there are no values, but there should be a list of people in the list. When I open the spreadsheet it works fine. Because the other region is four hours away, I can't just go and look at it on their computer. Is there something that the other region (or that I) need to do to make the spreadsheet compatible with Excel 2013?

Answer:How do I make an Excel 2007 worksheet work in Excel 2013?

Take a look here:

7 more replies
Relevance 60.68%


I am looking to create some code to move a sheet from one file to a new excel file. SO the code needs to open a new excel workbook and place the required sheet in the resultant new file.

I have managed to do this with an existing file "Moved Pivot" per the code below. This is ok but other people will be using my sheet so the location needs to be chosen by them. A new file seems to be the only solution?

Workbooks.Open Filename:="C:\desktop\Optegra Installer\Moved Pivot.xls"

Dim oTargetSheet As Worksheet
Set oTargetSheet = Workbooks("Moved Pivot.xls").Worksheets(1)
Call ThisWorkbook.Worksheets("PIVOT_TB").Copy(oTargetSheet)
Set oTargetSheet = Nothing

Any help much appreciated. Thanks


Answer:Solved: Excel VBA to move worksheet to new excel file

8 more replies
Relevance 60.68%

With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variable length field e.g. a persons name in a list or a field of fixed length other than a date as the script below uses?Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Turn off ScreenUpdatingApplication.ScreenUpdating = False'Make a copy of the data sheet and sort by date Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth)'Copy Column Widths and Header Row .Rows(1).Copy ActiveSheet.Rows(1).PasteSpecial Paste:=8 'ColumnWidth ActiveSheet.Rows(1).PasteSpecial 'Data... Read more

Answer:Excel Macro to create new worksheet in Excel 2010

I created a quick macro to help you out. This macro creates a new sheet and names it using the contents of cell "A1".Sub CreateNewSheet()
Dim NewSheet
Dim SheetName As String

SheetName = Worksheets("Sheet1").Cells(1, "A").Value
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), Count:=1, Type:=xlWorksheet)
NewSheet.Name = SheetName

End Sub
Law if Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 59.04%
Question: page length

Not for default but for a single page, I want to extend the printing below the point at which the print begins a new page.

Answer:page length


In what program do you wish to accomplish this? (Excel, Word ... etc)?

Have you tried setting a custom paper size, specifying it as longer?

2 more replies
Relevance 58.22%

So im using Excel 2010, and i making a timetable.

Right now the row going across saying period 1 2 3 they are all different sizes, some will be bigger and some would be smaller. I was wondering if there is a way to make them all the same size.

If you dont know what im talking about ask for a screenshot.

Im to busy to upload one now

Answer:Row Length in Excel

do you want the rows to all be the same height?

click on the first row number on the left - shift-click on the last one to select all the rows.

then right-click on the row numbers >> row height >> type in a number...

you can do a similar thing with the columns too.

is this what you meant?

4 more replies
Relevance 57.81%

I recently downloaded a pdf doc from the Intel support site. When I open the doc it says it is 14 pages long. When I try to print the pages all I get are very small (and I mean small )thumbprints of other pages
On closer inspection I find each of the 14 pages is not the usual A4 size page. The pages can be as long as 25 x A4 size long. In total the whole doc is about 200 normal A4 size pages.

Is there any way I can insert page breaks into the numerous pages on each page.

I suppose I could always set my printer for banner printing but I would end up with individual pages feet long.

Answer:Solved: pdf docs page length

8 more replies
Relevance 57.81%

I am new to Excel and can't find out how to limit my "book" to 2 pages. I know how to print only 2 pages (the other 424 are blank and will remain so) for my own purposes. However, I am e-mailing the file to others, so I want to simplify their work by eliminating the blank pages.

Still looking for a way to convert this to Word....

Thanks in advance for your help!

Answer:Excel - document length ???

10 more replies
Relevance 57.81%

Not very fluent in Excel. I am setting up a positive pay format for my company to transfer check information from my PC to a bank via an ASCII Flat-File. Question is, I have so many columns that need to be set at 10 characters fixed length.

Is there way for this to be done? Example if I key in a check for $1.95

I want it to automatically put it as 0000000195.

Can this be done?


Answer:Fixed Length in Excel

6 more replies
Relevance 56.99%

I have an excel spreadsheet which is 3 columns wide by about 100 rows long. When I print it out, it squashes the columns over to the left hand side of the A4 landscape page leaving a big blank space on the right hand side of the page. Because of the number of rows, it prints it out onto 2 pages.

I would prefer if it could have the first 50 rows on the left hand side of the page and then the second 50 rows on the right hand side of the same page.

I have chosen to fit 1 page wide by 1 page tall but all this does, is squash all the rows over on the left hand side of the page, still leaving the right side of the page blank.

I just cannot seem to make it do this at all.

Any ideas?

Answer:Printing a worksheet on one page

7 more replies
Relevance 56.99%

A while ago I installed Vista, then installed Word 2003 and then updated to sp3. Ever since then, my word 2003 doesn't format like every other word 2003 in the world. I see slightly less lines per page than other people.

For example, I just got a document with a table of contents that lists the last page as 29, but it's 35 pages when I view it. This screws up formating something awful. I have to take it to a campus computer for the final formatting so it looks fine.

Anyone know what might cause this? Thanks

Answer:Word 2003 incorrect page length

Make sure your stylesheets and templates are squared away.

1 more replies
Relevance 56.99%

I scan every piece of paper in our house into my "virtual filing cabinet." Most things work nice. But when I get a really long document, it usually cuts off the end of it when I feed it through the feeder. It's because it's configured to scan in 8.5x14 papers. I wish I had a program that would allow me to scan in 8.5 x infinity papers. It would just keep scanning until the paper finishes feeding and make the virtual page in the computer that length. Any ideas or suggestions?

Answer:scanning software with unlimited page length

Can't be done because the vertical travel of the scanning head/lamp is limited to 14-inches. It has nothing to do with the sheet feeder.

5 more replies
Relevance 56.99%
Question: excel worksheet

may be a dumb question but can i assemble a series of "loose" worksheets into a workbook? someone sends me a monthly report as an excel WS I want to put them all in one book from the folder they download to so I can analyse the data across all the sheets.
Regards Bloodaxe

Answer:excel worksheet

See if this helps click here

6 more replies
Relevance 56.99%

I have a folder with .csv and .txt files in it that I get every month from clients. 1. I need to get them into one Excel spreadsheet to do analysis with the information. I know I need to create a macro or a series of macros to be able to do this, but I really don't know how to begin. The information consists of three parts, I ultimately would like the macro to be able to seperate these individual parts and drop it on a seperate sheet within this workbook.... OR 2. I would like to be able to eliminate this first step and create an append query in Access to import the information into a table.

I ultimately need to have the information in Access and would much rather be able to do the entire process from an append query in Access.
thanks again.

Answer:.csv to Excel worksheet

6 more replies
Relevance 56.99%
Question: Excel Worksheet

I have a large Excel Spreadsheet that lists equipment (unit#, make, model, serial-no, branch location (1 to 5), status of equipment codes (0=avail, 1=on rent, 2=sold, 3=used for rent, 4=repair, 5=to be scrapped) and my assignment is to summarize how may pieces of equipment are in each of these categories at each location. Would I use a "countif" or a "vlookup" formula? I am using Excel 97.

Thank you

Answer:Excel Worksheet

None of them! I think you should use sumif or even sumproduct!
But also it can be done even easier using pivot tables!

If you wanna us assist you with that post a sample with some dummy date, bu with the real structure of the worksheet!

3 more replies
Relevance 56.99%
Question: Excel Worksheet

I was told if changes are save on current excel worksheet that you can recover the original worksheet or that it no longer exist on the hard drive is this true?

I need to find old worksheets. I created a worksheet to keep track of proceeds and updated it almost daily for 9 months. Is it possible for all of these worksheet to still exist on the hard drive?

Sorry with my pea brain I don't even know if this is a dumb question.

Thanks in advance,


Answer:Excel Worksheet

To the best of my knowledge, unless you saved each worksheet separately before making changes to it and then saved THAT worksheet, then you have overwritten the same file with new data. There would be no different files to retrieve practically.

2 more replies
Relevance 56.58%

For years I did something on my w98, using Word97, with my Epson LQ-570+ dot matrix printer.

I have tried the same thing on my wxp, using Word97, with my new Epson LQ-590. It won't work. Epson says it is a problem with Word97, of course.

I got the LQ-590 because my 570+ was old and probably not doing well, and because my w98 had failed and I was trying to get everything taken over by my newer wxp.

This is the problem:

I print out progress notes on transcription paper that is on a large roll, with tractor feed holes and with no perforations (i.e., the sheet is continuous).

The progress notes are of varying length. I don't want to have the end of the page split a progress note into two parts. But I also don't want to waste large amounts of transcription paper by printing a page that has a lot of space on it, as would be true if the last PN ended fairly high on the last page, or as would be true if I had to insert a lot of space in order to start the next note at the top of a page (to prevent it being split).

So how had I been doing it?

I would go through the long document of many progress notes and put in page breaks, making each page a "section." Then I would change (reduce) the page length (through Page Layout) so that the space after the last PN on that page would be eliminated. My Epson LQ-570+ would print each page with the appropriate (assigned) page length. Of course, my 570+ was obeying what Word97 was sending it with regard to page lengt... Read more

More replies
Relevance 56.58%

A couple of months ago my Excel worksheets became immobile - unable to be reduced in size or repositioned on my monitor. The minus button works, and the X button works, but the middle button works the same as the minus button. As a result, I see the sheet covering the entire screen or not at all. When I try to Restore from the bottom bar I only get the maximum screen again. The individual windows within the overall workbook can be repositioned within the maximum screen. I am using XP Home and Office 97 on a Toshiba Satellite Laptop, with a 19" CTX auxiliary monitor. Unable to find out what I did to cause this, or to find any help. Any suggestions would be greatly appreciated. IREBob

Answer:Excel Worksheet Resizing

13 more replies
Relevance 56.58%

I have 4 work sheets:worksheet one has pending ordersone ordered confirmed i have a column confirmed i have a row that says YesI want the information in that row to go to the next worksheet#2 which is on route to delivery. Once delievered I have a row that saids YesThat row would go to the next Worksheet that states Delivered row with Yes to next work sheet for billing.What is a formula to activate a whole row to move?

Answer:Excel Moving a row to another worksheet

There is no formula that can "move" a row. A formula/function can only return a result in the cell in which it resides.You'll probably need to use VBA to accomplish your "one ordered confirmed i have a column confirmed i have a row that says Yes"I don't understand this. Please try to explain it differently and we'll see if we can help.Posting Tip: Before posting Data or VBA Code, read this How-To.

2 more replies
Relevance 56.58%

I know this may be an obvious question, but I have a number of Worksheets in my Excel Workbook.

How do I send just a single Worksheet via e-mail?

Answer:Sending Excel Worksheet

It's not obvious at all. Questions:

1. Always emailing to the same person?
2. Email as an attachment? Or as part of the message body in Outlook?
3. Want a button on the worksheet?

You can check here:

3 more replies
Relevance 56.58%

I have created an Excel spreadsheet but cannot limit its size. In 'Print Preview' it fits nicely onto one A4 page, but when trying to email it spreads to 26 pages! How do I get rid of the thousands of extra rows and columns? I have Office XP.

Answer:Excel worksheet size

Try selecting the area that you want to print then File > Print Area > Set Print Area.

10 more replies
Relevance 56.58%

I have a question on adding a hyperlink from my intranet website to an excel worksheet:
The actual complete workbook is located on a LAN folder on our computer system... I want them to be directed to a specific worksheet w/in a workbook in excel. Is there a way to do this? Thanks so much!

Answer:hyperlink to an excel worksheet

I think all you need to do is something like this:

"C:\\My Documents\\MyExcelFile.xls#MySheet!A1"

If your sheet name contains a space, then you need to enclose it in single quote marks, like this:

"C:\\My Documents\\MyExcelFile.xls#'My Sheet'!A1"


1 more replies
Relevance 56.58%

In one workbook I have a number of worksheets that I wish to summarise.From the summary sheet is possible for excel to supply the worksheet name in a cell ?If so how ? I have tried '=sheetname!' but it does not work.

Answer:MS excel worksheet linking

except that you haven't defined the cell to be linked after the exclamation mark

10 more replies
Relevance 56.58%
Relevance 56.58%

Is there a way to remove or dim(so they can't be accessed) the functions on the worksheet menu bar, i know i can go into tools>customise and turn it off but i would like to do this using vba for a particular workbook/worksheets so that when the workbook is closed the menu bar returns, i think you can cover the worksheet menu bar with a custom menu bar but i am not sure how to do this either.

any help please

Answer:Excel worksheet menu bar

Yes, you should check the link I sent you (Pearson) you have to look a bit but there are many options like disactivation copy and paste, delete sheets, you name it.
It will take some thinking and doing but it's all there

1 more replies
Relevance 56.58%

I have a code that runs when an Excel workbook is opened. The code runs on all the worksheets within the workbook. When the code stops running the worksheet selected is always the last worksheet. There are 12 worksheets (named by each month).

How can I get the code to select the current month worksheet when the code reaches the end?

Answer:Solved: Excel -> Worksheet Name

6 more replies
Relevance 56.58%

Can not remove Worksheet menu bar from Excel 2002

Answer:Excel worksheet menu bar

14 more replies
Relevance 56.58%


I am sure this is going to be something simple?
When entering a number in a cell (i.e mobile) and clicking away from the cell
the zero is not saving? i.e 7766.
I did go into the format options and play about with the numbering and general options but was unable to solve?

Answer:Zero not saving in Excel worksheet?

First select the column and format as text.
Or enter with an apostrophe in front of the value.
Or you could format, for instance, a 7-digit number with a custom format of 0000000

3 more replies
Relevance 56.58%

i applied allinternalpasswords.xls to unprotect a worksheet. it has done it job. i opened the xls. when enabled macro i got a addin on the toolbar of excel. then i opened the problematic excel worksheet on the same window. i clicked on the addin and i got the link to remove password. it has done its job. now i still have the addin on the excel which i want to remove. how to remove it?
winxp-sp3-amd-asus-1 gb ram-

More replies
Relevance 56.58%

I have a document that is read only suggested...not password protected. I have been adding worksheets as necessary. I only have 6 worksheets at this time. Today when I tried to add a worksheet the worksheet option is inactive.

Any ideas?

Thanks so very much!

More replies
Relevance 56.58%

Have a project from work to fill in worksheets for phone calls received each week. Column headers are Phone Line 1,2,3,4,5. Rows are days of the week - with totals at the end of each column/row. Is it possible for me to have a separate worksheet which will add each of the weekly sheets up as a running total. I know I can do it as an autosum for existing sheets, but is there a way for it to auto-update to include each new weekly worksheet I make?

Answer:excel help - totals worksheet

Other than using a macro, this isn't easily possible. However, if you enter the names of the sheets - Sheet1, Sheet2 etc - in Column A of your summary sheet then the formula=INDIRECT("'"&A4&"'!M4")and copied down will retrieve the value of M4 from each sheet. You could adapt this to sum them.

4 more replies
Relevance 56.58%

i need a formula for my excel workbook

Answer:i trying to complete my excel worksheet

Here, use this one:=IF(IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)=5,INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,EQUIV("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5<>0,5,6)),-INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 56.58%

tab scrolling buttons will not advance the worksheetI've turned them off and don't know how

Answer:worksheet won't advance in Excel

tab scrolling buttonsNot sure what you mean.What version of Excel are you running?MIKE

14 more replies
Relevance 56.58%

In my excell, whenever I open an workbook, the colour or the cells and chart colours changes to different (randomly) than I originally set. Any information/help what's causing the problem and how to resolve this?Regards!

Answer:Excel worksheet problem

closing without any resolution.

1 more replies
Relevance 56.58%

writing a program in Excel... would like to have a "information page" where user info is collected then used to name tabs of worksheets in the program...
anyone have a solution?

Answer:Macro to name worksheet Tab in Excel?

1 more replies
Relevance 56.58%

I made an Excel worksheet and I want to set limits to where a user is able to tab to. Ie...The user starts in A2 and presses tab to get to B2, when the user presses the tab key again I want them to be taken to tab A3. Any Ideals? Thank you in advance for your help.

Answer:Excel worksheet tab order

Do you only want them to have access to the columns A and B only?? If so, try this.. Select the range of cells that you wan them to have access cells (EX: A2:B20). Right click on one of the selected cells and Select FORMAT CELLS. Then find the "Protection Tab" and UNCHECK the box next to" Locked". Close the FORMAT CELLS box. Then we are going to protect the worksheet and/or workbook depending on whichever you wish. This method will vary depending on which version of Excel you have. If it is the 03 version, go to Tools, Protect. If it is 07+, go to the Review Tab. Once you select Protect Sheet, you should see some options or "permissions" with check boxes next to them. Here we want to DESELECT "Select Locked Cells" so that they will only be able to select the cells that we previously "unlocked".BEST OF LUCK!

2 more replies
Relevance 56.58%

Hi All

I am trying to create a grading template on Excel. I have included hyperlinks, dropdown boxes and comments with no problem, but what I am trying to do is this.

I have the first 10 rows for static information - they don't change. I want to be able to change to next 10 rows without affecting the rows above. I want to be able to change column width, for example, without affecting what I have written above. Any ideas?

PS: If you know any sites that have intermediate tutors for excel, I'd love to know their addresses - especially any for info on creating grading templates.

Answer:Splitting an Excel Worksheet

11 more replies
Relevance 56.58%

Printer shows "Printing 1 of 1862" how do I get rid of this number

Answer:How to print a worksheet in Excel

It should be somewhere in your Printer Setup or Page Setup.MIKE

2 more replies
Relevance 56.58%

Hi, I am new to Excel and I just need help with linking to another worksheet. So if the user clicks on a cell, they will be taken to another worksheet with more detailed information. I realize this is very basic to most people but, as I said, I am new to Excel and I could not find information on this in the help files. Thanks for your help.

Answer:Excel - need help linking to another worksheet

ac11 said:

Hi, I am new to Excel and I just need help with linking to another worksheet. So if the user clicks on a cell, they will be taken to another worksheet with more detailed information. I realize this is very basic to most people but, as I said, I am new to Excel and I could not find information on this in the help files. Thanks for your help.Click to expand...

See the Help file for Hyperlinking

1 more replies
Relevance 56.58%

I have created an invoice using Office Excel.

As a test I sent it to own e-mail address.

The problem I have is when I received it, it was sent directly to my deleted folder.

I have both Norton Anti Virus and Internet Security installed on my PC.

Could these two programs have anything to do with it???


Answer:Sending Excel Worksheet

8 more replies
Relevance 56.58%

Could someone please tell me the shortcut to enlarge the worksheet in Excel.


Answer:Enlarging Excel Worksheet

Timeferret, depends what you mean by "enlarge".

From the Help file:

"If you use the Microsoft IntelliMouse pointing device to zoom more often than you use it to scroll on a sheet, you can set the wheel button to zoom instead of scroll. On the Tools menu, click Options, click the General tab, and then select the Zoom on roll with IntelliMouse check box."

This works with my non-M$ mouses too.


1 more replies
Relevance 56.58%

Is there a way of only displaying the columns which I am working with, on my Worksheet.

I am only using the columns A-K, but if I use the horizontal scroll button at the bottom of the screen I keep scrolling to unused columns to the right.

Answer:Viewing worksheet on Excel

8 more replies
Relevance 56.58%

If a2 is less than $65000, 0, but if a2 is $65000 to $70000, $100, but if a2 is $70001 to $74999, $200, but if a2 is $75000 to $79999, $300, but if a2 is $80000 to $84999, $400, but if a2 is $85000 to $89999, $500, but if a2 is $90000 to $94999, $600, but if a2 is $95000 to $99999, $700, and if over $100000, $800 . I will manually enter the amount in 'a2'. How do I do this calculation in my excel worksheet?

Answer:Excel Worksheet Calculation Help!

Why did you start a whole new thread?You could have just answered my query in the last one.Try this:=IF(A2<65000,0,IF(A2<=70000,100,IF(A2<=74999,200,IF(A2<=79999,300,IF(A2<=84999,400,IF(A2<=89999,500,IF(A2<=94999,600,IF(A2<=99999,700,800))))))))MIKE

4 more replies
Relevance 56.58%

I am trying to build a shop schedule to keep track of work being performed in 14 different bays. I have started the work sheet but run into difficulties with keeping the customer names below each other in the next cell. I end up with gaps in the work sheet where the formula does not find a value. Can someone assist me with completeing this worksheet? Please have a look.

Answer:Solved: Need Help with an excel worksheet

16 more replies
Relevance 56.58%

Hi ,

I had an excel sheet having 26 worksheet of 6mb size and that too file is sharing, now the actual problem is whenever i save a file or save as, without doing anything in the file one of the sheet randomly get disappeared, sometime the file size get decrease without doing anything.

Does any one have face any such problem, because what i think that there is no limit on file size and number of worksheet.

Ashish Sharma

More replies
Relevance 56.58%

Hello guys, this is my first post here.I have a work laptop that is on a domain. When I try to open any colored document in Excel 2002, I am not able to see any color in cells at all. Others can see them but not on my laptop. I tried the Detect and Repair option but it did not work. Do you guys have any suggestions? Thanks in advance and glad to be here.

Answer:Excel 2002 worksheet

Welcome to ComputerHope.What happens if you save a file in Excel 2000 with colored cells and open it?

8 more replies
Relevance 56.58%

Windows 7
Office 2007
Computer is approx 1.5 years old as well as the printer also.
Ram is a train load (gigs)

Having trouble with my Excel spreadsheets printing.
In any given Workbook, some worksheets print, some won't.
The ones that won't, I get a dialog box stating a few things, eg, not enough memory, drivers, etc., generally a generic dialog.
I have checked these avenues out, update Windows daily, as well as uninstalled my printer (HP C309a), reinstalled printer, I've had a computer technician out here a couple of times and he's done the same things I have done, but to no avail.
It may print, it may not. Depending on mood swing I guess.
Any suggestions?????????
Please help,
Thank you.

More replies
Relevance 56.58%

How can I restrict the use of an Excel worksheet to one computer? I believe that macros can be used to ID the serial number of a PC's hard drive and that an algorithm can be used to generate an activation code which would prevent migration.If it is possible (by any method), I would appreciate advice on how to achieve this.

Answer:Excel Worksheet Security

That is actually incredibly difficult to do.Would validation using the user's Windows logon name be an option?If you are trying to create a secure environment in Excel then forget it - Excel security is pants. Anubvody can crack it.

10 more replies
Relevance 56.58%

I have checked the threads and can't quite find an answer.

I have a spreadsheet with multiple worksheets (16), but one, lets call it worksheet 4, is very slow to be selected. The workbook itself opens quickly, and all the other worksheets select quickly enough.

This particular worksheet, when selected, displays whatever worksheet info I was on before, I get the old egg timer, and often get that the sheet is not responding. As long as I sit there long enough, it eventually displays. The formulas & formatting on this sheet are the same as on 8 or 9 of the others, and I am not having this problem with any other worksheets.

It isn't a small sheet - 2.7MB, and it is formula heavy.

Operating on Windows 7, running Excel 2007

Any ideas? I have checked for objects and hidden code and can't find anyhting.

Answer:Slow Excel Worksheet

What type of formulas do you have on that particular sheet? Are they referring to other cells on the same sheet, to cells on another sheet, to cells in another workbook...?
Even if it wasn't confidential (which I suspect it is) your workbook would be too large to upload, possibly even if you zipped it.
But unless we can compare the bad sheet with one that behaves normally or have a lot more info, I can't think of a lot to suggest.

3 more replies
Relevance 56.58%

I have been given the job of merging around 2,000 workbooks, each having around 12 worksheets. So I expect to have 24,000 worksheets in total. I am looking for a utility that will merge these onto one continuous worksheet, or if this is too big, I will initially group them into smaller worksheets. My problem is, I need to audit which workbook each row of data is taken from, so the utility must insert a column with the workbook name inserted against each row.

This is a nightmare, but I have to do it. Can anyone suggest any utility, at any price, that might carry out this function ?

Thanks in advance

Answer:Excel worksheet merge

A friend of mine goes here for help,try it

1 more replies
Relevance 56.58%

I did something to make a worksheet that I had prepared in Excel to go to my external drive G. Now each time I need to get the worksheet for some reason it tells me that it is not there, but I can see it in the external drive. I want to it on drive C.

Answer:Excel Worksheet in Drive G

Why not copy & paste or move the worksheet from the G: drive to the C: drive if that's what you want. What's stopping you?

3 more replies
Relevance 56.58%

I have a file in Excel. I recently added information to the file but when I tried to save it, a message said I cannot save it because it is a read only file. I check the Help information and it showed how to change the properties but when I tried that and went to remove the check mark from the 'read only' box there was no check mark in the 'read only box'. No matter what I tried I could not get the file to save the changes I made. Then it said to save with a different name but when I tried that it said I couldn't because the file was 'read only. I have run into a brick wall. Does anyone have an answer for this?

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD Athlon(tm) II X4 630 Processor, AMD64 Family 16 Model 5 Stepping 2
Processor Count: 4
RAM: 4094 Mb
Graphics Card: AMD Radeon HD 5700 Series, 1024 Mb
Hard Drives: C: Total - 476387 MB, Free - 409840 MB;
Motherboard: Gigabyte Technology Co., Ltd., GA-MA74GM-S2
Antivirus: Windows Defender, Disabled

Answer:Cannot save Excel worksheet

try saving with a different name
and closing the spreadsheet
Now using file explorer , goto the original file and rename that to somethink like OLD
now you should be able to rename the new file, back to its original name

have you emailed or shared the file at all
Anyone else on the PC - different user - open it
Does it contain any Macros at all?

I find this problem , when using dropbox or onedrive to save a copy into
often I have to save a copy , as dropbox/onedrive will be syncing the old file and locked it out

3 more replies
Relevance 56.58%

I have 250+sheets, summary sheet in excel. I did a formula an IF THEN statement it works ex; IF(sheet1'!$B$1<=5,sheet1'!$B$2,sheet1'!$B$3) but now have to repeat that formula 249 more time on my summary sheet.

Answer:Excel Worksheet Problem

Hi,If you are trying to do the same as before then the initial 'formula' looks like this:="XXXIF(Sheet" & G3 & "!$B$1<=5,Sheet" & G3 & "!$B$2,Sheet" & G3 &"!$B$3)"The formula you posted has an extra ' in it, sheet1'or a missing ' depends on how you look at it.The worksheet name can be used without single quotes if there are no spaces in the name, so =Sheet1!B1 is OKbut with a space it has to be ='Sheet 1'!B1Regards

2 more replies
Relevance 56.58%

I am looking to setup a simple worksheet, but I am having problems with tabing from one cell to the next. Is there anyway that I can assign a tab order to the cells, instead of the tab going where it wants to? This is after I have unlocked the cells that I need to type into.

Answer:Excel Worksheet Setup

Hi,If you are referring to how the selected cell changes after entering data, there is a setting in Options to set Up, Down, Left, Right or No move.I can't remember the exact location of this setting in Excel 2007, as I don't have that version on this PC.It's likely - Office Button - Excel Options (at the bottom of the pane), then select the Customize or Advanced tab from the tabs on the Left and look for Move Selection after Enter (or similar wording).Not sure if that helps you in your specific situation.Regards

2 more replies
Relevance 56.58%

Please can anyone remind me how to type in the formula for accessing data from worksheet 1 and using the data on worksheet 2 for instance all in the same work book. I used to do it but forgot how . I am using XP.

Answer:Excel - using data from other worksheet

Something like='First Sheet'!A1 + 'Second Sheet'!C3The ' are only necessary if there are spaces in the sheet name.

2 more replies
Relevance 56.58%

I need to print a worksheet (to make an order form) that contains 5 columns, but split into 2 so that one sheet looks like 2 sheets of A5 (A4 landscape, but wit two pages like a book - does this make any sense to anyone, !!!!!!!!!

Answer:Format Excel Worksheet

VoG's territory!!!

9 more replies
Relevance 56.17%

Hi i am Jo

would need help in finding the length of the third side of a triangle in excel

I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,

Answer:Find length of side of triangle in Excel

Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.

3 more replies
Relevance 56.17%

My lady wife is having a small problem with a formula she is trying to use in an Excel spreadsheet.

She is trying to make a formula that she can copy and paste into various spreadsheets she utilises to organise her staff's workflow.
The five staff deal with about 30 suppliers and she wishes to be able to associate each supplier with a particular member of staff, so, for example, if column A is 'Suppliers'and column B is 'Staff Member', a formula using the IF function is placed in column B using the following syntax:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark","")))))Click to expand...

This works just fine with only a few suppliers, but if the string is lengthened to more than about 9 suppliers, as here:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark",IF($A1="ffff","Rashmi",IF($A1="gggg","Laura",IF($A1="hhhh","Linda",IF($A1="iiii","Denise",IF($A1="jjjj","Mark",IF($A1="kkkk","Rashmi",IF($A1="llll","Laura",IF($A1="mmmm","Linda",IF($A1="nnnn",&quo... Read more

Answer:Solved: Excel formula length problem

11 more replies
Relevance 56.17%

Hi all,
I am wondering how to overcome the problem of Excel chopping off data.Is there a way to set a large limit or possibly keep the record length unlimited.This data is the results retreived from Access queries. The data after querying is exported to the Excel sheet via the following do command:

DoCmd.OutputTo acQuery, "queryName", "MicrosoftExcel(*.xls)", "Report" & ".xls", False, ""

Answer:Exporting from Access to Excel-length limits?

If you are trying to put the entire string as one line it will never work. I believe the charachter length is 255. You can however create a new cell in Excel for each record like a line break.

3 more replies
Relevance 56.17%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like


exit celll with ctrl, shift, enter

1 more replies
Relevance 56.17%

Excel has a limitation of 240 characters when saving a file as .PRN. I need to create an ASCII file of greater record length with multiple records.How can I do this? Is there an Excel workaround or will I have to use another program? Will Access allow me to do this?Thanks for any assistance in advance.Squeals

Answer:ASCII fixed length files in Excel

You MIGHT be able to do this using a macro click here

2 more replies
Relevance 55.76%

I budget with Excel and was wondering if it was possible to send an email to a specified email address and upon receiving the mail, Outlook executing a rule or something similar and it editing an Excel worksheet for me. My main goal is to, after purchasing an item, sending an email or text to a specified email address and then that info going straight into an Excel worksheet. Yes, I know I can do this manually but just out of curiosity I'd like to know if this is remotely possible. Thanks.

Answer:Is it possible to email data to an Excel worksheet?

You could do that with a Powershell or VB script that checks periodically for new mail to a specific account and then parses the mail message for particularly formatted message data.

The machine running it would need to have Outlook or another email client that supports COM object automation installed.

4 more replies
Relevance 55.76%

Could anyone tell me how to create a separate button within the worksheet to Find and Replace. I know this is a simple function to do from the edit menu; however, the people this spreadsheet is designed for have no computer knowledge at all and since we are all serving in a volunteer capasity, I don't know that the incentive is there to learn.Many Thanks!

Answer:Find Button in an Excel Worksheet

re: "I don't know that the incentive is there to learn."Well, they are going to have to learn something, like using the button, so I'm not sure how much you'll gain. It's only 2 click to the Find dialog box or a simply Ctrl F.What do you expect this button to do?Will it just bring up the Find dialog box or does it need to do more?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 55.76%

i have a set of excel worksheets (a workbook ?) with lots of years worth of data that needs to be kept, but i've copied to another name and now want to get rid of some of the old years data on the sheet that i'm working on i.e. current year; but that option is grayed on the edit menu. and no the sheet is not protected. thanks in advance.

Answer:{RESOLVED} Excel: Can't Delete Worksheet

Hi jimi,
Welcome, If you you want to delete the old data sheet, just find the sheet where you saved it and delete it with right click. Or highlight the data you want to delete in the sheet and hit dlete on the keyboard.

2 more replies
Relevance 55.76%


I am working on an Excel worksheet with over 200 checkboxes (CheckBox1, CheckBox2, etc.). I use VB6 to open the Excel worksheet but accessing the value of the cell where the checkbox is, is very challenging. I have used the following in VB6 code to no avail:

'the cell contains a checkbox, and i want to see the logical value (checked or unchecked) so i can assign a 'corresponding numerical value but the content it's showing is 'Empty'. It's a protected worksheet btw.

xlsWB1.WorkSheets(strWorkSheetName).Range("H8").Value 'this shows me an 'Empty' value

Also tried this one but gave me this runtime error: 'Unable to get the CheckBoxes Property of the WorkSheet class'


Also this without success:

xlsWB1.Activesheet.CheckBox5.Value 'Error says: Object doesn't support this property or method

I am not sure how to proceed with this and suggestions would be most welcome.


Answer:Referencing CheckBoxes in an Excel WorkSheet


I do not think the check boxes are linked to the cells.
The follow code will loop thru the
"Forms" checkbox and the "ActiveX" checkboes.
You will not that they use a integer. If you have 200 of them then change the sample to 200.
Sub test()
'' For ActiveX ''
Dim i As Integer
For i = 1 To 4
With ActiveSheet
If .OLEObjects("CheckBox" & i).Object.Value = True Then
MsgBox ""
End If
End With
Next i
End Sub


Sub test1()
'' For "Forms checkboxes"'''
For i = 1 To 36
With ActiveSheet
If .CheckBoxes("Check Box " & i).Value = 1 Then
''Do something ''
End If
End With
End Sub

2 more replies
Relevance 55.76%

Can anyone please help. I protected an excel worsheet and now I've forgot the password.Does anyone know how to recover the password or maybe some workaround?This an important worksheet and I really do need to make some alterations on it. Any help will be appreciatedDougie 2003

Answer:Excel worksheet forgotten pasword

We cannot provide methods for breaking passwords for obvious reasons click here

1 more replies
Relevance 55.76%

I'm working on a sales journal and need to have the total for a certain set of repeated values. I have over one hundred entries per month. How do I get away from entering cell names and numbers repeatedly. For example, I need to have all the 'gas' totals add up automatically without having to type in all the cell names. See attachment - it's much easier to explain using it.

Plz HELP!!!

Answer:Solved: Excel Worksheet Dilemma

Take a look at the SUMIF function.


2 more replies
Relevance 55.76%

My difficulty is in Excel, writing a formula to calculate a variable commission. e.g.

Sale of a widget
$0.00 to $12,500.00 = 6%
If it is sold for:
$12,501.00 to $20,000
Comm is 6% on the first $12,500.00 and the balance of $7,500.00
is at 2%
If it is sold for $20,001 to infinity:
Commission is 6% on the first $12,500.00
and 2% on the next $7,500.00
and 1% on the amount exceeding $20,000.00

Answer:Solved: Excel Commission Worksheet

7 more replies
Relevance 55.76%

Hi, I'm really hoping someone can help with this problem- I've Googled it non-stop. I have an excel sheet where I would like a row to be copied from the 'open cases' worksheet into the 'closed' worksheet when the value 'closed' entered in column K. I have the following macro:Private Sub Worksheet_Change(ByVal Target As Range) Dim C As Range If Intersect(Target, Me.Range("K:K")) Is Nothing Then Exit Sub For Each C In Intersect(Target, Me.Range("K:K")).Cells If C.Text = "Closed" Then Dim otherSheet As WorksheetSet otherSheet = Sheets("Closed")C.EntireRow.Cut Worksheets("Closed").Cells(Rows.Count, "D").End(xlUp).Offset(1).EntireRow End If Next End SubThis pastes the row but deletes any information which was is in the 'Closed' worksheet. Any help would be brilliant. Thank you,

Answer:How to use to macro insert row into new worksheet in Excel.

My knowledge of VBA is just above nil, but wouldn't it better to Copy then Cut?You might try changing the line that reads:C.EntireRow.Cut Worksheets("Closed").Cells(Rows.Count, To something like:C.EntireRow.Copy Worksheets("Closed").Cells(Rows.Count, See if that works for you.MIKE

3 more replies
Relevance 55.76%

I'm working on a Macbook Pro with Mac OS X, version 10.6.7.  Recently, when opening a new excel worksheet or existing file, the toolbars do not appear at the top of the sheet.  I open View>Toolbars and both Standard and Formatting are checked.  I have to uncheck one, reopen View>toolbars, recheck the one I unchecked and then the space for the toolbars appears without the toolbars.  Finally, when I place the cursor in that space and click, they will appear.  Each time I close and reopen a file, I have to go through the same process.  This annoyance started recently, but I can't link it to anything that may have caused it.  Any help would be appreciated.

Answer:toolbars do not appear when excel worksheet is opened

I would try repairing the permissions using disk utility that can help resolve little glitches like the one you are having

2 more replies
Relevance 55.76%

Hi - at work, I produce invoices in Excel and would like to know if I can print the addresses directly on to envelopes as you can in Word.I know - it'd be easier to put the address in the appropriate place for a window envelope, but the letterhead is too deep (we can't change it - don't ask, it's a definite no!!) I also know I can print labels, but just want to know if it can be done the other way.Thanks

Answer:Printing addresses from Excel worksheet

Well I use Window envelopes but I will give what you want to do a try and see what happens. I am pretty sure it must be possible to it.

9 more replies
Relevance 55.76%

I am using Vista and MS Office 2003. When I set the display appearance settings to High Contrast Black (for viewing with Retinitis pigmentosa) get no colours, either text or cell. please help

Answer:No colour in Excel 2003 worksheet

9 more replies
Relevance 55.76%

Hi, I'm in the process of sending a dvd-rw drive back to samsung,but I first have to have the RMA number,samsung sent me a RMA request form as a excel worksheet, I've never used excel before, when I select a cell and start to type nothing happens, what do I have to do to activate the curser

Answer:how do I type a word in excel worksheet

You shouldn't have to do anything except click in a cell and type.

8 more replies
Relevance 55.76%

I have always used microsoft works and to make a list of names, addresses, telephone numbers etc. it was very easy in works data base, but I now have windows 10 and I cannot open .wdb files.
I don't know how to name columns or insert a row in excel. Do not understand their explanations in help

Answer:Naming columns in excel worksheet


3 more replies
Relevance 55.76%

Hi All I have a excel workbook that I wish to loan somebody but I want it to work on only one day. My question is how to do this? I can get todays date to come up in a cell and then get IF function to give a true or false answer but then what? Ideally I'd like it to change something or move a formula so that it doesn't work right so what do i enter under false, can it be made to throw an error saying wrong date or something? Is there something else better to do this?Thanks FB

Answer:Date protect excel worksheet??

but maybe this will help until somebody (VoG, whisperer, simsy etc) come along.You can put =today in a cell and the date on which you want the workbook to work in another.As an example, put =today in A1 and 1/06/05 in B1 In the workbook open event put the follwingPrivate Sub workbook_open()If sheet1.cells(1,1) <> sheet1.cells(1,2) then activeworkbook.closeEnd subThis will check if today is the date you want the sheet to work and close the sheet if not.Tas

9 more replies
Relevance 55.76%

only one of my workbooks has missing arows on the sides/corners and load with grey borders within the window frame. How did I lose them and how to get them back, please

Answer:how do i get arrows on the sides of excel worksheet

Do you mean the scroll bars, and what version of Excel do you have?

7 more replies
Relevance 55.76%

A friend of mine has MS Works on his PC and I sent him a MS Excel 97-2003 worksheet.

He can open the worksheet to read what is there, but he cannot use it as the formula's do not work.

He does not want to purchase MS office at this time, is there a patch, add-on, etc he can run, to use this worksheet.


More replies
Relevance 55.76%

I have been given a disc with an excel worksheet containing some photgrpahs I need to save. I have tried copying and pasting thwm into Paint but the colours are somehow reduced, any ideas? thanks

Answer:Sving photos that are in excel worksheet

It may be that paint is not the best program. If you can't get Corel paint shop pro or Adobe photoshop, ther is a free prog called GIMP click here , that you can download and might suit your purpose

1 more replies
Relevance 55.76%

Hi there

I know that it is very easy to copy and paste an Excel worksheet into a notepad. However, my boss wants me to write a macro in Excel that can do that automatically, since we have staff that is not comfortable in using Excel. I tried to record a macro to get me started but that did not work. Any ideas??


Answer:Exporting an Excel worksheet into Notepad

16 more replies
Relevance 55.76%

I am trying to do a search of a worksheet, starting at my current position, looking for a substring in each field (the substring could be character or numeric). If the substring is found, that cell becomes the current cell and the user is asked if the search should continue. If the substring is not found, the user is asked if the search should continue at the top of the worksheet. I am sure I am going about this wrong and really could use some help. Below is the code I have so far.

Thanks in advance.

Sub Search()

Dim datatoFind
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer

On Error Resume Next

currentSheet = ActiveSheet.Index
datatoFind = InputBox("Please enter the value to search for")

If datatoFind = "" Then Exit Sub
sheetCount = ActiveWorkbook.Sheets.Count

For counter = 1 To sheetCount
If IsError(Cells.Find(What:=datatoFind, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate) = False Then Exit For
Next counter

If ActiveCell.Value <> datatoFind Then
MsgBox ("Value found")
End If
End Sub

Answer:In Excel find a substring in in a worksheet

11 more replies
Relevance 55.76%

Does anyone know of an app which is easy to use that can retrieve the password for an excel worksheet so I can uprotect it to make adjustments.either freeware or a payed app will do.

Answer:retrieving excel worksheet password app

click here

1 more replies
Relevance 55.76%

How do I print the worksheet name/title when I print the workbook?

Answer:printing worksheet names in excel

Look up Header & Footers, they let you include:File PathFile NameSheet NameCurrent DateCurrent TimePage NumberNumber of PagesEtc. Etc.MIKE

2 more replies
Relevance 55.76%

I have several excel files. In each of these excel files, I have one worksheet that contains important data. I want to create a batch file that can copy this worksheet from each of the excel files and save each one of them in a separate file. (The extracted worksheet can be saved in any format) Thank you in advance for your assistance

Answer:Extracting an excel worksheet into a file

re: "I want to create a batch file that can copy this worksheet from each of the excel files and save each one of them in a separate file."As opposed to copying the sheet, I think it would be easier to delete all the other sheets and then save the remaining sheet as it's own file. The original file wouldn't be impacted because it wouldn't get saved.Is it always the same sheet in each workbook? Perhaps the same name or same location (Sheet1, Sheet2, etc.)?Somehow we'd have to tell the code which sheet in each file we're interested.You'll need to provide some more detail before we can offer any assistance.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 55.76%

I am trying to print the gridlines in an Excel file. I did a search and followed the instructions, went to File/page setup/ then in the Print section I put a check mark in the gridlines box, clicked OK, then clicked Print but did not print the gridlines. I followed the instructions to the letter. What can I be doing wrong?

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 32 bit
Processor: Intel(R) Celeron(R) CPU B800 @ 1.50GHz, x64 Family 6 Model 42 Stepping 7
Processor Count: 2
RAM: 1893 Mb
Graphics Card: Intel(R) HD Graphics Family, 818 Mb
Hard Drives: C: Total - 238372 MB, Free - 196442 MB;
Motherboard: Acer, HMA51_HR
Antivirus: avast! Antivirus, Updated and Enabled

More replies