Over 1 million tech questions and answers.

Excel 2013 Opening Size of Sheet

Q: Excel 2013 Opening Size of Sheet

First, I always close sheets in the position and size that I want them to open in.

However, with my new Office 2013, when I open a sheet, or even first open Excel and it comes up with a new sheet, it's opens in a small window and the window is positioned in the left lower quadrant of my screen, about 2 or 3 inches in from the left and up from the bottom.

If I then grab the title bar and slide the window to the left and off screen, until my cursor is off screen, then the window snaps open to fill half the screen on the left side. BUT, really annoying, if I then open a second sheet it gets opened exactly as the first did, small. It does not matter how many times I slide it left anfd make it snap to the size I want, it still opens new sheets in a small windows.

How do I stop that? How do I force all new sheets, or even the first start of Excel, to open in a window on the left half of the screen?

Preferred Solution: Excel 2013 Opening Size of Sheet

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 http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2013 Opening Size of Sheet

Looks like Excel does not remember "snapped in half" window position.
You would have to position manually your window the way you like without letting snapping to kick in (window can be resized by moving edges of the window). This way your window position will be remembered and used for a new window.

Read other 4 answers

Hi guys. I'm new to this forum so I hope I am posting in the right one. I have a simple question which I hope has a simple solution. We'll see :).

I would like to know if there is an option anywhere which will make it an possible to open an excel file in excel from a link rather than inline in internet explorer.


A:Opening up Excel sheet in Internet Explorer.

Right click on the link and click on 'Save Target as..' then you should be able to open it outside of IE.

Read other 2 answers

Using excel 2010
I have a master list of items,product code, and price.
I would like to be able to use a separate worksheet and be able to use a drop down menu/list to select and add individually to my worksheet.
Example, there mmight be 1000 items in my master list and I might like to select/import as such 11 items into my worksheet.
Any suggestions?

A:Solved: Importing selected rows from Excel sheet one to Excel sheet two

Read other 6 answers

 I have an issue with Excel and IE.  When I am
trying to open a .xlsm file from a https website by clicking on File>Open With, it pops up a windows asking me to "Choose a digital certificate" with certs listed by the name : [email protected] and Issuer: Communications Server . I have
to click on ok several times still it does not open the file. The site is using HTTPS. The strange thing is that I can open the file if I use FireFox.

Any help would be appreciated.....

Please help !!

Read other answers

Hi Members,

when I open any XLS or XLSX file after few seconds or after doing any activity in any xls/xlsx file, Excel 2013 crashes (Office 2013 is updated to latest). There are no third party plugins enabled in Office 2013.

Note: I don't have any issues with Word 2013 or PowerPoint 2013.

My operating system is Windows 7 Ultimate with SP1 (64 bit)

Below mentioned software's are installed and with real-time enabled...
ESET NOD32 Antivirus 6.0.308.0 (64 bit)
Malwarebytes Anti-Malware 1.70
Zemana AntiLogger
System Explorer 4.0
Stick Password 6.0
Hard Disk Sentinel 4.30
Application Error from Event Log
Faulting application name: EXCEL.EXE, version: 15.0.4454.1503, time stamp: 0x50b592fe
Faulting module name: EXCEL.EXE, version: 15.0.4454.1503, time stamp: 0x50b592fe
Exception code: 0xc0000005
Fault offset: 0x0127b52e
Faulting process id: 0x3e0
Faulting application start time: 0x01ce11ca85e9d41f
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
Faulting module path: C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
Report Id: d1ff267b-7dbd-11e2-95be-50465db76fa6

Application Log Error message

I don't know what is causing Excel 2013 to crash. Requesting members to help me fix this issue.

Thanks and Regards

A:Excel 2013 crashes after opening and using any xls/xlsx file

Hi Rafales,

Please try start 'Excel' in 'Safe Mode' and check if it works. To start it in 'Safe mode automatically', click this link: http://go.microsoft.com/?linkid=9668693
- Click 'Run' in the 'File Download dialog box', and follow the steps in the 'Microsoft Fix it wizard'

If 'Excel' still does not work as expected, a conflict with another program is likely. Try to restart 'Windows' in 'Safe mode', and perform the previous steps again to run 'Excel in Safe mode'; and check results.

Do reply with the findings; will take it forward from there.

Read other 9 answers

I need to copy n number of rows from a sheet in my local machine to a sheet in fileserver.
My requirement is - if I select last 2 rows in the sheet in my local machine I need the rows to be copied after the first blank cell in the sheet in fileserver.
Also it would be helpful if the macro code is only in the local sheet and not in the fileserver sheet.

I am a newbie to macros pls help....

Read other answers


I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.


A:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

Read other 8 answers


I need to paste data from one worksheet that is unfiltered (not hidden) onto a worksheet that is filtered. I need to paste onto visable cells only, ignoring the hidden rows. Currently, my data is being pasted onto both visible and hidden rows.

I know its possible to paste only visable data, ignoring hidden cells, but I need to do the reverse of this. Pasting non hidden data onto only visible cells. And I hope I am explaining this well.

Please do not suggest a vlookup because this would take entirely too long due to the nature of my data and this project. Also, I am not skilled enough to do code, so keep it simple...

Suggestions please?

A:Solved: Pasting in excel from unfiltered sheet to filtered sheet

Read other 6 answers

hi guys...i posted regarding this file a few times...and is still coming back to haunt me!

i need some help here....especially now that the ppl at the office need the information to be drawn out differently.

ok. here's the scenario:

i have an excel file with 8 sheets

"Questionnaire" sheet is to be filled out by a rep and has some drop down lists to populate the "POtemp_NY" sheet.

ampaper, edmar, sterling, stoneglo, strauss and uneeda are all venders with lists of their products...with their prices.

"POtemp_NY" is the master sheet where all the information must show on

The problem is, i need to have the "POtemp_NY" sheet populate the description, units, and price when someone enters a value in the "Units" column on a vendors sheet. Also, i would need the "POtemp_NY" sheet to continue to list the products on the next lines if there are multiple products with values in their "Units" cell.

Any help would be GREAT!!!!

Thanks in advance!

the file is attached for reference! thanks!!!

- mark

A:Solved: excel: populate sheet from list (fr another sheet)

Read other 16 answers


I have an application called BT Billing Analyst. This application has an option to open a report in Excel.

When I used Excel 2007 the report data opened in sheet 1 of an Excel workbook and some information on the report was put on sheet 2.

I recently upgraded to Excel 2013 and now when I open the report in Excel the report data is populated on sheet one but after that the first 25 lines get overwritten by the information that should go to sheet 2.

Is there any way I can fix this?


A:Excel - Sheet 2 data getting written to sheet 1

You may have to go to the BT Billing vendor to resolve this. Perhaps an updated version is available. 2007 is xml based like 2013 so I am surprised there is a conflict. But I don't think there is anything in Excel you can do to resolve.

Read other 2 answers


I want to copy the original sheet into another sheet.

I have sheet1 tab.

if I use this code:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("Sheet1")

it created sheet1(2). but I want to specify my tab name.

if I chnage it and run:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("helloworld")

It fails.. error comes up.

How do I make it work?

Thank you

A:Solved: EXCEL: copy sheet to another sheet

Hi sk0101,

rename it after copying:-

ActiveWorkbook.Sheets("sheet1 (2)").Name = "helloworld"


Read other 2 answers

Im wondering if it is possible to do this before i start trying...

I recieve an email containing an excel sheet containing several peices of info such as:
Etc Etc... Now when i open this.. i need the information posted into specified columns in a new excel document where it will have
Any help given appreciated.

A:Excel - Auto export data into specified excel sheet

Read other 6 answers


Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:



We're used to Office 2003, so this is a big jump at work for us



A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.

Read other 1 answers


I have a problem in merging two worksheets in excel as the two sheets have different no of rows in it. and i need to merge the two sheets in a new worksheet, and in that work sheet i need to remove the duplicate values present in the both work sheets.

anybody can help me to do that.

A:Need to Merge two excel sheets in one excel sheet.


What version of Excel are you using. If it's 2007 then I think you can copy the data to another worksheet and select the range then use the "Remove Duplicate" option that you find it the "Data" tab.

Read other 1 answers

I'm on a network across the UK running Excel 97 under Nt4, shortly to change to XP.

What I want to do is to have all offices place data on a spreadsheet to build a monthly picture.

I thought about placing the Excel spreadsheet on my office's shared drive, which is accessible by all other offices.

Each office's shared drive runs under its own server on an overall network. i.e. all the servers are linked. LAN?

Is it sufficient to send a shortcut icon for the spreadsheet to users where the short cut refers to the original file on my shared drive on my office's server?

And what would happen if two persons were accessing the file at the same time? What happens when one or both of them press Save?

A:Excel Sheet for many

Read other 7 answers

I am having live data on my excel sheet 1 for 50 stocks. On sheet 2 I am having watchlist of 10 stocks.
Now how can i get live data for my watchlist stocks on sheet2 from sheet1.
I am using excel 2007

Read other answers

In column A of excel sheet I have numbers running numerically from 1 to 100. If I insert a row after, say, 50, the only way I can re-number that column is to insert 101 against the new insert and then highlight the column and click on sort ascending. Surely there is some way that I can drag from the top figure down and they should automatically sort in numerical order?

Any help would be much appreciated.

A:Excel sheet

Hi Troopecca and welcome to Vista Forums

Are you trying to say that you have a spreadsheet of 100 rows labeled 1 to 100 and that you want to insert a row after, say, row 50 and have the subsequent rows renumbered so that the inserted row is 51 and the row that was 51 becoming 52 etc until row 100 becomes 101?

Read other 2 answers

Dear Sir.

Actually I need help to make one excel sheet, which is required for Grocery Mart.

I make 2 sheets
Sheet 1 is for inventory
Sheet 2 is for daily transaction.

Sheet 1 = A column is for product code (all product have different code)
Sheet 1 = H column is for Sold unit (all product have different sale)

Sheet 2 = B column is for product code (all product have different code)
Sheet 2 = C column is for Sold unit (all product have different sale)

I want to connect sheet 1 to sheet 2 ,

I wish that when I type Product code in sheet 2 (column B) and put number of sold unit in same sheet (column c), it will be also change (mean add) according to code in sheet 1, sold unit column i.e. Sheet 1 column H.

Is it possible , If yes please inform me formula. I can also send you my prepared sheet through attachment if you provide me any email address.

Awaiting for your favorable response.


A:Need help with Excel sheet

Read other 9 answers


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

Read other 1 answers

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

A:Solved: Excel search does not work Excel 2013

Read other 7 answers

I've got three sheets in a workbook. The following macro will work on the first sheet when I open the workbook, but will not work when I switch to either of the other sheets. I've tried by putting the macro in "this workbook", in each sheet, and in all four places. What I want is the macro to freeze row 5 at A5 so I can see the headings and bring up the next clear row to about a third down from the top, where I can enter data. That's what the End(xlUp), etc. and SmallScroll Down, etc. is all about. I randomly picked A300 because it's below any data.

Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In Me.Worksheets
Application.Goto Reference:="R1C1"
ActiveCell.Offset(4, 0).Range("A1").Select
ActiveWindow.FreezePanes = True
Application.Goto Reference:="R300C1"
ActiveWindow.SmallScroll Down:=6
ActiveCell.Offset(1, 0).Range("A1").Select
Next ws
End Sub


A:Solved: auto running a macro when opening a sheet

1. In ThisWorkbook is correct, but you're using the wrong event.

2. I don't know if this can be an "exact science".

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
On Error Resume Next
ActiveWindow.FreezePanes = True
x = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & x + 1).Select
ActiveWindow.SmallScroll Down:=x / 30
End Sub

Read other 2 answers

Can I automatically copy cell data (text) to the sheet tab name? If so, how? What about copying a cell to a header/footer?

A:Excel 97 sheet names

Paste the following code into a new module: -

Option Explicit

Public Function sheetname(Target As Range)

Debug.Print Target.Address
If (Target.Address = "$A$1") And ((Not IsEmpty(Target.Value)) Or (Target.Value <> "")) Then
ActiveSheet.Name = Target.Value
End If

End Function

Then Paste the following code into Microsoft Excel Objects Sheet 1:-

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Call sheetname(Target)
End Sub

The code will place the value contained in A1 into the name of that sheet. See the attached spreadsheet.

To use this function from other sheets you will need to paste the second piece of code into the appropriate sheet object.


Read other 1 answers

Good afternoon,

I am trying to set up an inventory sheet that can keep updating as my inventory updates...
i.e. say I started with 10 pieces of item a, then I sold 1 piece of said item, then I purchased 15 more of the same item. I can do the basic formula that will give me a number of 24 pieces in stock, what I am looking to do, is to have a sheet that will reset the number of items purchased to zero while keeping my running total items correct...

Any help you guys can offer will be highly appreciated!!

thanks in advance

Read other answers

Okay, first........I SUCK at Excel.

I am on the Virginia Horse Council's Trails Committee and we're working with the VirginiaOutdoors website to chart the trails in Virginia available to equestrians and to provide information about them in one place. I'm riding these trails with a GPS and am charting them in order to get information on what type of terrain, how long they are, and to provide GPS points for intersections and whatnot.

Now.......I have this excel sheet, but as you can see, it's not really very user friendly. But I really hate Excel, and I just can't do anything else with it. Can someone PLEASE make it look better? I was thinking that the columns for "mailing address" and "phone" could be combined into "contact info" or something.....but that's about the extent of my ideas.

A:Need help with making Excel sheet

Read other 13 answers

How to set Password in an Excel sheet, I tried, anybody please help me out

A:How to set Password in Excel sheet

Do you want to set it manually or with Visual Basic?
If it is Manually look in the main menu under Tools>Protection>Protect Sheet

Read other 1 answers

Hi, I am new to this forum and am not an expert in Excel formulas and all.
I was wondering if anybody has an idiots instruction that tells me how to filter a load of dates that I get in an excel sheet to exclude weekends.
They are not consecutive dates.
For example: if given the column below how could I identify which days of the week they are and subsequently exclude weekends...if indeed there are any there???


Many Thanks for any help with this.

A:Excel Sheet Query

Read other 7 answers

Is there a known way to stack sheet tabs in an excel spreadsheet, rather than have them all on one row?
I have 15 sheets where they all are categorized as one of three types. I would like to have them in three rows.
Is this possible?

A:Excel Sheet Tabs

Read other 6 answers


I've inhererited a spreadsheet at work which I update on a regular basis. The role of the book is to list all our School Doctors, The Schools they cover, The School Nurse who also covers the school & the amount of pupils.

Each Dr has their own sheet. Each sheet has a 3 columns; 1 for the schools, 1 for the nurse & 1 for the number of pupils ie:

School Nurse Pupils
Any School Any Nurse 100
Another School Another Nurse 99 etc etc

Because some of the nurses appear on a number of different sheets I'm finding it hard to check i've got all the correct schools for each nurse. So I was wondering if I could do a sort of Summary Sheet which would list all the schools for a relevant nurse ie:

Nurse 1

School4 etc etc

I know I could probably do this easier in Access but I'm loathe to use it as when I leave here (shortly) know will know how to use it.



A:Summary Sheet in Excel

Read other 7 answers

hey all, hope someone can help.

I have two sheets, sheet 2 "Data" has a list of current Tenders we have (actual sheet has nearly 700 and growing). Sheet 1 "Renew" I want to Autofilter, the data on sheet 2 "Data".
Perhaps a button or even auto, although Automatic on change of data would be brilliant.

Here's a link to the sheet.
Download Data.xls
I have a contract period calculator and a form that will show all the necessary information.
Any help on improving my forms would be good too, especially as it doesn't seem to work in Excel 97.

Tenders are basically the process of choosing a contractor for contracts by a procurement team.

A:excel: autofilter to another sheet - please help

Read other 14 answers

i am to create a log book, one sheet per item, there are dozens of items. each sheet is to be identical save for the id number and a few cell which look up said id number in another workbook for a few details. doing this will take me ages if i am to do it one by one - is there a way to do it quickly?????

thanks for any help

A:excel sheet generation

Closing duplicate.

Please do not start more than one thread for the same issue.

Read other 1 answers

Is it possible to make an input sheet in a workbook that will basically allow me to type in data into the provided cells and then hit enter and it add that data to a totals sheet in the workbook? After you hit enter the data fields become clear and you can put in another round of data.

I am not sure I explained that correctly but if you have an idea of what i am talking about please let me know how to do this or at least point me in the right direction.

Thanks for your time!!

A:Excel INPUT Sheet???

Read other 12 answers

Hi guys n Gals,

could anyone help me with formulas in excel to create a summary sheet,

i currently have a workbook with 15 sheets all named differently according to area of the business i am in and need to take only certain figures from certain pages onto the summary page

so kitchen = kitchen 1 i30 + kitchen 2 i30
dry = dry i30
drinks cupboard = drinks cupboard 1 i30 + drinks cupboard 2 i30

i have tried =SUM( then shift clicking the relevant sheets (1 and 2 in this case) i want to include, and the lines on them sheets, but when i got to do my next line on the summary page and do the =SUM(shift click but it always includes the preceding sheets figure to

i dont know if what i have written makes any sence but i hope it does, any help would be greatly appreciated as i am a complete novice :/
many many thnx in advance mart

i will upload a pic of the summary page which should make sence of what i just wrote :/

A:excel summary sheet

Read other 6 answers

Please bear with me as i try to describe this scenario.

One our Win2003 server there is a shared drive which contains a folder for for financial worksheets for our remote locations. Each excel worksheet is accessed by only one particular person in our corporate location and one person (the plant manager) of each plant. Each plant (about 27 of them) has its own worksheet.

Each worksheet has several "sheets" within it, and one sheet (called "Current") in particular causes the whole document to blow out.

When that particular "sheet" is print previewed or printed, an error occurs (Excel has encountered an error and must close), the worksheet shuts down, reopens and Excel automatically recovers the document.

If, I go into ANY cell in that particular sheet "Current" and make even the slightest change (resizing a column, adding a punctuation mark, etc.) move to another cell, go back to the original cell, delete my changes and save the sheet. It is fixed.

I have tried everything I can think of:

Detect and repair
Repair of Office
Reinstall of Excel
Copying the sheet inside the worksheet
Copying the entire worksheet

The next thing I am going to try is creating a new Windows profile for the person at Corporate. Since she is the common denominator for all worksheets, I believe she is the one that is causing the corruption...somehow.

Hopefully this made sense, and hopefully someone can offer some advice on this problem.

Thanks in advance.
... Read more

A:Excel Sheet Error

Read other 13 answers


Hoping you can help. I have an excel spreadsheet which contains several sheet containing company spend (a budget spreadsheet) for each region.

Each sheet contains the follwoing fields:

Date of Ordering
Date Invoice received
Invoice Number
Purchase Order Number

I want to create a couple of sheets; one that will list every record in the workbook (displaying the following fields: Date Description Cost Status) and another summary sheet which will display all of the records in the workbook where the status matches "purchase order".

I have a feeling it's something to do with Lookups or something similar but I'm clueless when it comes to these.

If anyone can help that will be great.

A:Excel Summary Sheet

Read other 16 answers

Hi, I recently began learning Office 2010 and have an Excel specific question. The thing is, when I print an Excel-file I prepared the print is real tiny, almost unreadable as if the sheet should be divided into 6 or 7 pages rather than the 3 pages that I have somehow managed to get it down to. It looks fine on the screen, but the printout...
A magnifying glass is called for to read the file unless somebody can clue me in as to what I'm
doing wrong.

I'd be most hankful for any and all advice 'cause I'm at wits end, and the sooner the quicker

ImageShack? - Online Photo and Video Hosting

A:Printing Excel-sheet

Check the Page Layout tab, then the Scale to Fit section. Here you can set the height and width of the printed version in pages - you may have something here.

Read other 9 answers

Hi there, all wizards.

Sitting here at work trying to build, for me way to comprehensive automated excel travel expense report form.

I dont know much about vba, so i'm lost, and i dont know wether i can get the controls to find what i would like in one table in different sheet. For if i choose one "country", i want a control to show this country in one base cell, then to collect corresponding amount in next set of colums, so that i can get the form to calculate as much as possible with less input from user.
That was problem nr 1

2 problem is
i like to use form control textbox to place data in different cells, telling 1: start date, 2: end date. third cell i want to calculate how many days it has been in between.
This i also want for calculating hours.

REason for this is to use these values as base to wether calculate in the findings with corresponding values in other sheet. When done with all my final layouts, and formulas i lock the form sheet, and leave only some cells open in sheet with reference tables.
Cant upload file here, limit says 200kb (way low)

A:excel sheet form

Read other 6 answers

I need a VB code to open an exisitng excel file and sort a column and store in diff excel sheet.eg i have a column data s.no,name,class......who all r in classA should be sorted and store in new excel sheet..as like all classB,C,D,E should be stored in diff excel sheet....................

Read other answers

I have a spreadsheet containing several worksheets
It should show names of worksheet at bottom of desktop!
Today it just gives me blank worksheet and F1 for NAME at RIBBON....
However if I do print & preview I see the expected text and I can print it OK
I had been working with page breaks  yesterday  with different file
HELP would be appreciated

Read other answers

I'm using Office 2000 on an XP machine. Is there a way to filter data to a different sheet within the same workbook? This is easily done in QuattroPro using the data query functions, but I can't figure out how to do it in Excel.

Thanks for your help.

A:Excel - Filter to a new sheet??

Advanced Filter can do this, the trick is to start the process from the destination sheet.

Say Sheet1!A1 = "Team", Sheet1!B1 = "Points", & the actual data is listed below.

Set up Sheet2 the same (A1 = "Team", B1 = "Points"), then enter the query criterion in Sheet2!A2 (e.g. "Team A").

With Sheet2!A1 active, go Data -- Filter -- Advanced Filter (if you get an "Excel cannot determine labels" message, just click OK).

In the Advanced Filter dialog, "Action" = copy to another location ; "Criteria range" = $A$1:$B$2 ; for "List range", highlight whatever's in the box, click Sheet1 tab, select the original data ; click in "Copy to" (Sheet2 should become active again), then on a cell (e.g. A4). Click OK.


Read other 2 answers

Dear Sir,

When I try to change the color of the text / numerical in Excel sheet ( say from black to red) a message pops up :
Microsoft Office Excel has stopped Working - Windows will close the programme & notify you if a solution is available.

The data is safe and the file opens up again . I can do all normal work therein but again upon changing clour of font, it does the same thing as detailed above.
I need to have color fonts as it is a necessary for my work.

Kindly guide me for a solution.

Kindest Regards & thanks in anticipation,


A:Excel sheet shuts down.

Hi there, and welcome to the board!

Unfortunately this is fairly ambiguous - through no fault of your own. Some things to try:
disable all add-ins, close Excel, open, try the file again
Try the file on another computer with the same version of Excel
Open Excel is Safe Mode and try the file again (excel.exe /s)
If there are macros, disable macros or comment out code, close/reopen and try the file again
What version is this in? Also, do you ever get a solution that's been found?

Read other 1 answers


First off, rookie here.
Just trying to work on a personal project that I plan to use at work but wanna get it to work first.

At work we have LOTS of paperwork and am trying to make a small applet that will allow us to enter the information from one console and have it send that data to another and have it formatted into an Excel spreadsheet (HAS to be printed out).

I'm not so fussy about the connection part, if can be done on same pc that is fine.

Could anybody suggest some methods???


A:using VB to make Excel sheet???

You could use something like Access to input information onto a form and have the output saved as Excel. I am not really sure what you are trying to accomplish and not really sure what you mean by sent to another console. What is wrong with just using Excel and emailing it to another person on the network?

Read other 1 answers

I'm using an Excel worksheet (2007) that has macros to populate a form that I want to email to various people. I used to do it with no problem in the 2003 version, but now I get a message that says, "Unable to Sign - If using Microsoft Publisher or InfoPath Please resend as an attachment." This error message is in a dialog box that has the label, "Send as message not supported from Microsoft Publisher or InfoPath" I wasn't aware that I was using either of those applications, just Excel and Outlook. I don't care if the message is digitally signed before sending or not, I just want to send the form out. Any ideas?

Read other answers

I need to create a macro that when run accomplishes the following:

Creates a new sheet and names it the same as the value of the currently active cell in the current worksheet.

The macro should only work when Sheet1 is active, and only if the active cell is within a range in column A e.g. > A5.

If a sheet of the intended name already exists then it should display an Error Message.

The new sheet should actually be a copy of sheet 2.


Sheet 1 = 'Test List'
Sheet 2 = 'Blank Test Form'

If I enter '010' in Col A, Row 10 on sheet 1, and then run the macro (via a button) it should copy Sheet 2 into the workbook giving it a name of 'Test010'.

If poss, I'd like it to create the new sheet and place it alphabetically along the sSheet names at the bottom of the workbook!

One for XLGURU please?


PS I am about to start a VBA course so this will help me.

A:Macro to add a new sheet in Excel

Read other 16 answers

I'd like to know if there's a way to decrease the number of rows and columns in an Excel sheet. For instance I need a spreadsheet of 50 columns & 100 rows. Thanks for the help.

A:Sheet dimensions in Excel


In short, no. What you could do though, is to select all rows below row 100, right click the selection and choose Hide; do the same for the columns > 50. This will in effect 'grey out' those undesired. You will still be able to scroll down, but no information will be entered there.

Read other 1 answers

I have what seems like a simple puzzle in MS Excel. I've messed with it for days and it's kicking my butt.

I need to do a lookup from one sheet to another.

The target sheet is a calendar which is a schedule for shift work.

The source sheet shows everybody's availability by horizontal date index with an "X" meaning not available, blank if available, and a shift designator "A", "P", "N" when scheduled for the shift.

Looks like
1 2 3 4 5...
John X X A X...
Jack A A X X P...
Jill P P P ...

So on the target sheet (looks like a wall calendar) I'd like to have it look for the "A" and fill in the name.

Lookup doesn't return accurate results.

indirect(address(match(...))) doesn't translate to the other sheet.

Appreciate anyone who can help.


A:Excel Lookup on another sheet

I'm terrible with I&M, but you can have a look here:

Read other 2 answers


Basically what i'm trying to do is to record my diet for a 7 day period in excel for bodybuilding.

For this I thought it would be good if i could have a big table of all the food with their protein, carb and calorie content stored, so that when filling in my food diary, i could just choose one of the foods from a drop-down list and all the nutritional info would come up next to it and be totalled up for the whole day.

I've done excel in school, but that was a while ago, so i'm a bit rusty!

Any help you can give would be really helpful!

Thanks a lot, Theo

A:Excel Diet Sheet

I hope some of these links might be of interest 'til someone comes up with exactly what you are looking for:





Read other 1 answers