Over 1 million tech questions and answers.

Excel 2013 Numbering Format

Q: Excel 2013 Numbering Format

In Windows 8.1, I?m puzzled with the number format in Excel 2013. I write 24000 and the cell shows 240, or I write 10 and the cell shows 0.1

The format cells / number does not have anything to change the format to see the number I type

How can I change the numbers format to see what I write?

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Excel 2013 Numbering Format

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.)

RELEVANCY SCORE 70.4

Maybe this can't be done.

Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I figure how much she can spend.

What I'm trying to do is to keep only the last 4 digits visible. 549.67 would only show 549.67 until I drag the mouse over it with left button down.

My wife only has one allergy. Money

A:Excel 2013 Help needed with a Conditional Format

Is this anywhere close?

font color=Automatic
=If>4 digits(left digits=White)
or smaybe something like
font color=White(last 4 digits=Automatic) ?

Read other 6 answers
RELEVANCY SCORE 69.6

Hopefully this can be done easily.

Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I check it
.
How can I keep only the last 4 digits visible?
549.67 would only show
549.67 until I highlight it with mouse.
My wife only has one allergy. Money !
 

A:Solved: Excel 2013 Help needed with Conditional Format

Read other 11 answers
RELEVANCY SCORE 61.6

Does anybody know how you change the font of the footnote numbering in a document? Whenever I insert footnote, I get the number (1, 2, 3 ...) in "Times New Romans." I am using "Arial" for my writing, but I want the font "Tahoma" for the numbers of the footnotes. Is there any way to modify the font?

Thanks, M.

A:Office Word 2013: How to change the font of footnote numbering?

You change the Header and Footer font as you would change a font in text, simply by selecting the text in header or footer and choosing the font you want to use:
(Click to enlarge.)

Kari

Read other 9 answers
RELEVANCY SCORE 57.2

This is driving me crazy! I just got a new computer with Windows 10 and Office 2016. I'm numbering entities in Excel and find that as soon as I hit row 100, the count goes back to 1. I want the row count to be what it is 101, 102, etc instead of 1, 2, etc. There is probably an easy way to fix this but I can't find it.
 

Read other answers
RELEVANCY SCORE 56.4

I use Excel 97 and for the life of me can't figure out how to change where the number goes. Is there a way to place it elsewhere than the bottom right hand corner?
 

A:Excel Page Numbering

Yes you can change the page numbers.

Go to File, Page Setup. Header/Footer tab and click on the Footer botton. Set the page numbers there.
 

Read other 1 answers
RELEVANCY SCORE 56.4

We have recently upgraded from version 2000 to 2003. The page numbering I had which started at 15 by entering page number+14 has changed from 15, 16, 17 etc to 24, 34, 44 etc.

When I simultaneously enter the centre and left footer with the same formular the number correctly show 15, 16, 17 etc. However if I then delete the right hand footer the centre footer changes to 24, 34 ,44. If I then delete the centre footer the right hand footer also changes to 24, 34 etc.

Please help, as I want to use right hand footer to match page numbering from word.
 

A:Excel - page numbering > 1

Read other 12 answers
RELEVANCY SCORE 56.4

I am trying to number the first column by 10's for example the #1 is in rows 1-10, the #2 is in rows 11-20 and so on. Is there an easy way to fill it in or do I have to fill it in manually using the fill down?
 

A:Excel Numbering Question.

This isn't 100% but will do most of the work.

With 1st number in A1, 2nd number in A11, whatever you like in A21.

Select A1:A21. Press F5, click Special, check Blanks, click OK.

Type =A1, press CTRL+Enter.

Reselect the range, copy and paste special (values).

Time for bed. Rgds,
Andy
 

Read other 2 answers
RELEVANCY SCORE 56.4

I just got a new computer and bought Excel 2016. I'm very happy with both but am frustrated because I sell books on Amazon and have to list them. When using Excel 2007, once the listings went over 100, they would continue to number 101, 102, etc.
 
However, with Excel 2016, once I go past my 100th row, the rows start numbering at 1,2, 3, etc. again and it's driving me crazy. If I have over 400 different items, I'll have 4 different sets of 100 items and they won't be numbered sequentially. This makes no sense at all as a default.
 
In any case, I am sure there's a simple way to get consecutive numbering to exceed the 100th row but I can't figure it out.

A:Excel numbering starts over again at 100

Try this on a blank sheet first. Type 1 to 4 in consecutive rows. Highlight the cells from 1 to 4. In the bottom right corner is an anchor. Left click and drag down until you get to 400 or more. 
 
https://support.office.com/en-us/article/Automatically-number-rows-in-Excel-2016-for-Windows-598f6fb5-a5dc-4474-af7a-6cce5559ad92

Read other 6 answers
RELEVANCY SCORE 56.4

I have an Excel file with several worksheets in it. Some of the worksheets are two pages, and I want to put page numbers on the second page only --- and leave the first page blank. Is there a way to do that?

Thanks.
 

A:Page Numbering in Excel

Nope. Sorry.

Unless you wanted to write a UDF of your own (example here) and manually input the formula into every page except the first. But that sounds crappy.
 

Read other 2 answers
RELEVANCY SCORE 56.4

I just got a new computer and bought Excel 2016. I'm very happy with both but am frustrated because I sell books on Amazon and have to list them. When using Excel 2007, once the listings went over 100, they would continue to number 101, 102, etc.
 
However, with Excel 2016, once I go past my 100th row, the rows start numbering at 1,2, 3, etc. again and it's driving me crazy. If I have over 400 different items, I'll have 4 different sets of 100 items and they won't be numbered sequentially. This makes no sense at all as a default.
 
In any case, I am sure there's a simple way to get consecutive numbering to exceed the 100th row but I can't figure it out.

A:Excel numbering starts over again at 100

Try this on a blank sheet first. Type 1 to 4 in consecutive rows. Highlight the cells from 1 to 4. In the bottom right corner is an anchor. Left click and drag down until you get to 400 or more. 
 
https://support.office.com/en-us/article/Automatically-number-rows-in-Excel-2016-for-Windows-598f6fb5-a5dc-4474-af7a-6cce5559ad92

Read other 6 answers
RELEVANCY SCORE 56.4

Hi all
I need to number a large amount of cells. is there anyway you can highlight 200 cells in a collum and then automatically number them from 1 to 200 in one go.
Thanks in advance for the help.
 

A:Numbering cells in excel

Read other 6 answers
RELEVANCY SCORE 56

hi all,
I have an excel workbook with several worksheets, each a page a long (i dont want them all merge in one sheet). I need to number them sequentially as they appear on the workbook.
The only way i can number them now is by going into each worksheet and inserting a page footer and enter a number manually !

Is there a way whereby all worksheets/pages are numbered automatically and more importantly page numbers changes if a new sheet is inserted ?
Thank u kindly.
Edd.
 

A:Excel - Workbook page numbering

Read other 12 answers
RELEVANCY SCORE 56

Hi guys i am a real novice when it comes to excel and i have taken on a task at work that maybe over my head (Job Cuts Looming so have said YES i can do that easily). can anyone help???

I am trying to get an excel and a word form to self generate a URN for a First Aid Report Form and also a Purchase Order Request form i have created both forms but carnt figure out how to get them to assign a new URN after the old form has been submitted, Any help will be greatfully appriciated
 

Read other answers
RELEVANCY SCORE 56

Hi folks,
I have become a subscriber of this forum because most of you that will be reading this will know far more about what I will be asking about so Hello all thanks for listening to my waffle and hear is your starter for ten.

I am trying to make a number in a single cell in a form generated from an Excel work book page, increase by 1 every time that the form is saved and printed, as a serial number.

e.g. when the form is printed it is automatically saved in a register and the number is incremented by 1, the cell is L2 on the attached file.

I am using Excel 2003 and Windows XP Home.

So folks dose that sound feasible?

Simon.
 

A:Sequential Numbering in Excel 2003

Read other 6 answers
RELEVANCY SCORE 56

Hello,

I would like to create a formula that searches a cell in column B that contains "***patient subtotal," and then returns a number in column A if that formula is true. However, I would like there to sequential numbers in rows below where the formula is true.

For example
Column A Column B
1 ***patient subtotal
2 ***patient subtotal
3 ***patient subtotal

I used the formula below, but it doesn't work. May you please help me?
=IF((SEARCH("***patient subtotal",B22)),ROW())*1-countif($B$22:B22,0))),"***patient subtotal","")
Thanks!
 

Read other answers
RELEVANCY SCORE 56

Not sure if this question has been asked or not i tried to search but i cant seem to find anything on the forum. So my question being:

A1=1
A2=2
A3=3
A4=4
A5=5
A6=6

But here is the kicker if i delete one of the other numbers i want it to auto fix the rest of the numbers and continue:

A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4

So any ideas? Thanks in advance for the help!
 

A:Sequential Numbering Excel 2007

If the sequence you want is:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
Then just enter:
A1=1
A2=blank
A3=2
Then select those three cells (A1, A2, and A3)
Grab the grabpoint at the bottom right of cell A3 and drag downward.

From that I got:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
A7=5
A8=blank
A9=6
A10=7
A11=blank
A12=8
A13=9
A14=blank
A15=10
A16=11
etc.
 

Read other 2 answers
RELEVANCY SCORE 55.2

Hi

I'm trying to design a little receipt for my part time hobby/business and would like to have a sequential receipt number thats automatically updated in the receipt number cell (currently G1).

Also I have a macro that clears the filled boxes by copying blank cells on top of them and thus wiping them, is there anyway I could use this macro to wipe the receipt but also update the receipt number?

Hopefully that makes some kind of sense!

Thanks in advance for any help

Dan
 

A:Sequential receipt numbering in Excel 2000

No need to do the copying blank cells thing, nor get too complicated if it's just a small personal project. Something as follows should suffice:

Sub ClearReceipt()
Range("B2", "B4").ClearContents
Range("G1") = Range("G1") + 1
End Sub
 

Read other 2 answers
RELEVANCY SCORE 55.2

I have viewed another page in this firum that shows this but it did not work for me.
I simply want to open my Excel Template, fill in the data and save as to My Documents. When I open the Template again and fill in and save I want the invoice number to be the next in the sequence.
I have not done much with VBA or Macros so treat me as a Dummy ;-(((
Peter
 

A:Excel 2007 auto invoice numbering

Read other 7 answers
RELEVANCY SCORE 54.8

Dear Sirs: I am having a great deal of trouble trying to figure out how to get Excel 2003 to automatically number items in list. PLEASE HELP!

 

A:Problem w/ automatic numbering of items in MS Excel 2003

What kind of numbering -- 1, 2, 3, etc.? & what do you mean by "automatically"?

If you have a list in A1:A100, you can enter 1 in B1 and then:
select B1:B100
(with ALT held down), press E then I then S
if "Step value" = 1, press ENTER.

Then B1:B100 will be 1, 2, 3, etc.

If you want a number to be automatically entered in B whenever you enter a list item in A, you'll need a macro (probably).
 

Read other 2 answers
RELEVANCY SCORE 54.8

I have designed a simple printable invoice for my own work on Excel 2003 and want to generate consecutive "Invoice Number" numbers each time I print it.

Is this possible ? Office Online has not come up with what I need. It's kind of urgent. Using Vista .
Many thanks for suggestions.
 

A:I need automatic consecutive numbering on each invoice(excel 2003)

Read other 6 answers
RELEVANCY SCORE 54.8

I have been using Excel (now 2007) to keep records of items that we give free after a certain amount of purchases are made. Each year I simply carry over to the new year and delete all those who received the free item so that I start with a clean slate.

I did this yesterday and now noticed that the numbering on the far left column skips the number I deleted and although there are perhaps 30 names there - the numbers are showing up to 237.

How do I change the numbers so that they run consecutively from 1 to 30.....please...in layman terms please!

Thanks..
 

A:Excel 2007 Change Left Side Numbering - HELP!!

Read other 16 answers
RELEVANCY SCORE 54.8

When removing/deleting a row from a spreadsheet, the leftmost auto numbering column does not renumber and therefor skips one or more numbers. Is there a way to have it auto renumber?

Excel 2000
 

A:Solved: Excel: Left auto numbering column

Read other 6 answers
RELEVANCY SCORE 54

Hi,

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
RELEVANCY SCORE 54

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
RELEVANCY SCORE 52.4

I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.
 

A:Solved: Excel 2007: conditional format when date displayed as format d

Read other 8 answers
RELEVANCY SCORE 51.2

Hi to everyone.
Hope somebody can help me.
Since I have this notebok Lenovo Yoga 2 Pro with screen resolution of 3200x1800 I have problem on visualization email in Outlook 2013.
When I open email in the reading pan, show me long and narrow. I hope this is due to wrong office setup but I tried everything and no change.
I enclosing a jpeg to shw my problem and understand better.
Thank you for quick answer.

Ciao
Matsalleh

Read other answers
RELEVANCY SCORE 50.8

Help! I have been using Access for years with no issues. Now I have a database created in Access 2013 (Office 365) that will not open. I get the error "database is not a recognized database format" or something of the sort. I tried copying it off the One Drive and putting in my Documents, thinking that it might be because it was in the cloud, but same message. I want to try Compact and Repair, but I cannot get to the database at all, so can't do that operation. I've read you can open Access and do a C & R on another database, but that doesn't work. It forces you to choose a template, and if I create a blank database and then go to C & R, it does not bring up a list of databases--just does nothing. Holding shift while opening Access does nothing except open it as usual. Any ideas at all out there????
 

A:Access 2013 says my database is unrecognized format

You should be able to open Access without opening a database and then do the C&R on the problem one, you hava been able to do so on all versions up to 2007, I have not tested 2010/2013 though.
Another alternative is to open a blank database and try an Import from the problem one.
However if it is totally corrupted neither method will work, that is why it is issential to have a backup copy.
 

Read other 3 answers
RELEVANCY SCORE 50.8

MS OFFICE 2013 all files are in read only format

In default Admin account i am able to edit these files and save them in same document.
when i tried in a new test account with full control also still i am facing the issue as read only.

i tired in registry given full control to everyone this one also not solved the issue.

When i made changes it is asking me to create a new file but not saving in same file name.

please help me to fix the issue


thanks in advance

A:MS OFFICE 2013 all files are in read only format

This should answer your question:
Plan Protected View settings for Office 2013

Read other 1 answers
RELEVANCY SCORE 50.4

Hi

I've recently had to get a new computer and decided to try a Mac. Everything works fine, however, I have excel files which I have transferred from my old Windows laptop which, when opened on the Mac, have not kept the colour formatting from the windows version. Is there anything I can try to see if the original colour formatting can be accessed or will I have to re-colour them all from the start?

Thanks for any help, advice, support in advance.

Wayne
 

A:Excel 2003 (Windows) to Excel 2011 (Mac) colour format issue

Hi Wayne, It's not the MAC, the issue is the fact that the newer versions of Office (also on MACS) have diffrente shading of colors.
The basic colors in Excel 2003 are not always the same.
I imagine that there is color formatting but that the shades are off, correct?

I think it will have to be hand-work, I don't know hoe Microsoft thinks about this but, well, compatability is an issue here

Maybe there's a setting somewhere that tells it to use the standaard (old version) settings, but I doubt that.

You'll need an inside-out Microsoft expert for this, I think.
 

Read other 1 answers
RELEVANCY SCORE 49.6

hi guys I need your help, all of my important Data inside my PC in separate D:1TB HDD I stored in the PC. But suddenly today all of my D:1TB WORD 2013, TEXT, .JPEG Photos converted into .abc format, this extension added to all of my very important files, which I am having from last 15 years,

So I can't loos this Data at all, all files becomes like this
mical.docx.abc
john.text.abc
Robert.jpeg.abc

please help me, how to get my all of my files into original proper format,

I mean node of the files are opening, when I click on it,

I already Format & reinstall Win 7 from Scratch,
And I already reinstall MS-Office also

After doing all, still I could not get back my files, I am struggling from last 20 hours continuously,

Any help appricated,

Thanks

A:All of my Word 2013, Text, .JPEG Photos converted into .abc format, un

http://malwaretips.com/blogs/remove-restore_files-txt-and-abc-virus/

this is exact problem and message I am getting

Read other 1 answers
RELEVANCY SCORE 49.2

Is anyone good at using excel? I need help with making an input box that will allow me to enter numbers, And these numbers will automatically register with my other work sheets in my work book.
 

A:Excel 2013

Read other 8 answers
RELEVANCY SCORE 49.2

Hi,

Need assistance on the below Excel issue.

When we open excel file, other minimised excel files get maximised, help me with the resolution.

Read other answers
RELEVANCY SCORE 48.8

I just installed Windows 10 on everyone's laptop here and now I have a bunch of users that their Excel will ocassionally not save or will have graphics issues.  I have tried several suggestions, such as checking their .com add-ins, updating their DisplayLink, and trying to use it in safe mode.  Nothing has been able to fully fix it.  Has anyone else experienced this?  I have heard that Microsoft knows about the issue but has no fixes for it, but I have heard/read that so much that I just don't want to fully believe it.  If anyone has seen this and found a fix can you please help?  Thanks in advance!

Read other answers
RELEVANCY SCORE 48.8

I'm trying to open an add in in excel 2013 and I keep getting this message
 
Compile error
The code in this project must be updated for use on 64 bit systems
Please review and update Declare statements and then mark them with the PtrSafe attribute
 
I have no clue what to do

A:Excel 2013 error

Hi,
 
Most likely you have Office 2013 64 bits installed and the add-in only works on Office 2013 32 bits!

Read other 7 answers
RELEVANCY SCORE 48.8

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.

Cheers.

A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers
RELEVANCY SCORE 48.8

Hi, I have a desktop win7 32 bit OS and installed MS Office 2013. I can print from ms word and other word application accept for excel. Every time I press print a message pops up saying "no printer found". I also cannot set the brother mfc 8910 printer to default printer, it displays a message "operation terminated"

How can I get excel to print and have the printer set as default?
Also I want to know where I can go to see the details / specs of ms office suit that indicates 64 / 32 bit?
 

A:ms excel 2013 not printing.

Read other 8 answers
RELEVANCY SCORE 48.8

That?s new to me and can?t find any answers on the web. The attached snip is from a workbook I made a few months back and all was ok but now as you can see the first row looks like its missing because there are labels on that row which I can?t see.

In addition, the heavy vertical black lines are not mine (when I click on them it says ?Oval Object #...? and there are 2 vertical rectangles which are not mine either.

The only explanation I can give is perhaps an update from MS change all that

If I copy this workbook as an Excel.xls and view it on my other laptop which has Excel 2000 all is normal and copying this normal workbook and open it with my Excel 2013 the same strange things happen again

Any idea how I can recover my original
 

Read other answers
RELEVANCY SCORE 48.8

Excel 2013 can't be opened on my Windows 8.1 laptop, can any Microsoft specialist help me?

Read other answers
RELEVANCY SCORE 48.4

Hi I'm having trouble preventing Word 2013 from automatically formatting a document. I have defined a multi level list associated with the headings style. If I have a line of text that has a number at the beginning of the line, word will automatically apply the heading style that corresponds with the number when instead I just want to create a bulletted list. The little auto format lightning bolt drop down does not appear at all. I have turned off every possible auto format and auto correct option there is, but word is still changing the format. Any help would be appreciated.

before:

1 heading one
1.1 sub paragraph
2 each

after:

1 heading one
1.1 sub paragraph
? each

A:Word 2013 can't stop auto format of heading multi level list

I don't use Word much these days, but having a look through my Word 2013, I see you might be able to make changes. With Word open select Design from the top menu & over on the RH side is Paragraph Spacing, click on that & from the drop down menu select Custom Paragraph Spacing.
This will open a selection of tabs you can use to change your document settings.
Click on Edit & scroll down to find one that says List Bullets. You can also select New Style & this will give you a lot more options that you can change.
Also note down at the bottom there is an option to select for This Document Only or for all Documents based on this Template.

I have not tried any of these options, but give it a try & see how you go. If you regularly want to us this style you can save it as a template as a basis for future documents.

Read other 1 answers
RELEVANCY SCORE 48

I used to know how to do this but I have forgotten... I need to have the numbers for Section 1 (title page, TOC, etc) be like i, ii, iii, etc... and then Section 2 (Chapter 1) needs to be page 1. Nothing I've tried is working, and I know this is simple, I've just forgotten how to do it! Thank you for your help!!
 

A:Solved: Page numbering in Word 2007... different numbering for Section 1 and Section

Read other 9 answers
RELEVANCY SCORE 48

Windows 7 & Excel 2013 2GB RAM
When I begin typing into a cell, even just the = sign, it stays blank for 2-3 seconds. Seriously !
Any idea what could be causing this? It's like watching grass grow.
 

A:Excel 2013 freezes and hesitates

Read other 6 answers
RELEVANCY SCORE 48

I hope I have the right forum. I created a drop down list in excel 2013 but I want to link specific data to each selection in the dropdown box to be displayed in other boxes on the spreadsheet. I have the dropdown list on a separate sheet from where I store the data to be displayed.
 
Ex.
select 1 and populate a,b,c,d
select 2 and populate e,f,g,h
select 3 and populate I,j,k,l
etc
 
something like
sales area/     employees
south/             Bob, Jane, Russ
North /            Jeff. Carl, Pat
West/             Richard, Matt, Josh
 
When I pick South I want the corresponding employees to be displayed..
 
I want to link 5 items to the drop down list selection. The data is arranged in a row (left to right) but I have the display boxes arranged in columns (top to bottom). I can change that if need be. only one dropdown box will be used.
 
I have used excel before but still a novice at most of the more intermediate functions.
 
I hope that makes sense 

A:excel 2013 drop down lists

I think you should be able to achieve this with the "vlookup" function.
 
VLOOKUP function

Read other 3 answers
RELEVANCY SCORE 48

I have a Toshiba P855 with 16GIGS of memory and Office 2013. I have been on the phone with Microsoft for 13 months complaining about how Excel 2013 Office Pro keeps crashing randomly. At first they told me my macro was corrupt. I knew it wasn't because it runs all day long on office 2010 on my desktop which has Windows 7 it was on and off with them for weeks and hours and they finally said that it has to be something wrong with my laptop. It will crash sometimes when I go to copy and paste simple task on a new spreadsheet without any Macros or no conditional formatting and it is real pain in the butt. When it does crash I can load that same file to my memory stick, open it on my desktop, close it, re open on my Toshiba Office 2013 and it runs for a while.

Is there ANYTHING that can be causing this from the laptop drivers or other programs. I'm at a lost and feel Microsoft once again is giving me the run around. It gives me different crash reports within excel too so they are not always for the same reason it crashes but when it crashes anything I have open within excel crashes too. It's ONLY excel that crashes. No other programs and my lap top is fine. It is NOT my anti virus. It will crash when I try and cut and paste ONE CELL

Things I have done, repair 3 times, removed and re installed twice, removed all add ons, changed printer spool, bring up in safe mode, reloaded graphics drivers, spoke to Toshiba, BTW Microsoft says its Toshibas fault and Toshiba says its Microsof... Read more

A:Excel 2013 has been crashing for over a year, HELP!!! Tried everything

Hi larbec7.

Read this MS website concerning your problem. Be sure to follow the link shown in the Answer section as it give a lot more info. See if there is anything there that helps you.

Excel 2013 is crashing sometimes with error 0xc0000005 - Microsoft Community

Read other 1 answers
RELEVANCY SCORE 48

Hi All,

So recently I've been having trouble with numerous Excel Spreadsheets on Excel 2013/2010

Issues have included excel freezing, taking a long time to open multiple (large) spreadsheets, copying and pasting taking 3 minutes or more.

Just to give some background; let me start by stating that the excel sheets in question are large in size with lots of links to external sources. I would also add that these spreadsheets where originally created on 2010 rather than 2013. My computer is also running on a corporate network for which i'am an admin.

However, the spec of the machine i'am using, in my opinion, should be more than capable of running these large sheets:

HP Z240
Xeon CPU 3.30GHz
16GB
250GB SSD
Win 7 Pro

To remedy these problems i have tried numerous troubleshooting including:
Increasing the RAM to 32GB
Turning off protected view via GP
Installing Excel 2010 alongside 2013
Installing 2010 x32
Ensuring all macro's are enabled via GP
Rebuilding the box entirely (software)

None of these have resolved the issues.

I've now found that i have exhausted my knowledge on this issue and so, I'am reaching out to see if any one has any suggestions with how to fix this.

Any help anyone can provide is greatly appreciated!

Read other answers
RELEVANCY SCORE 48

How to open the damaged. XLSX file 2013? The Microsoft Excel "Open and Restore" function doesn't help.

A:Excel xlsx file 2013

Hi, and welcome to TSF.

Try the solutions on this page; https://support.office.com/en-gb/art...a-801ddcd4ea53

Read other 4 answers