Over 1 million tech questions and answers.

Excel 2013 Drawing Tools

Q: Excel 2013 Drawing Tools

I use quite often the Excel drawing tools for basic wiring diagrams and I find very annoying the format menu.
So a draw a simple line, then I click on format menu to select the color and again to select the line thickness.
Is there any initiation file or similar I can set the default color / line thickness?

Preferred Solution: Excel 2013 Drawing Tools

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 Drawing Tools

Why are you using Excel, there are so many other programs out there most are even free!

Read other 1 answers

This might be some kind of a simple error but I have no clue what to do about it. I'm sorry that the program language is in Finnish but I think you can get the point. I've tried googling several times now and no one hasn't seem to have this problem (or everyone else knows how to fix it..)

Read other answers


I created a table using Excel, and from that table I created a line chart using the Chart Wizard.

After the chart was complete, I then added data using the drawing tools "add text icon."

When I want to included the data table when printing, the text that I added prints fine.

Now here is where the problem occurs. if I just select the chart, the text disappears, and if I do a print preview or print, the text doesn't show up. The text that I added is behind the chart in a cell. I tried to bring it forward but that doesn't work.

What am I doing wrong?

If I create the table in Power Point, and then add the text, everything prints fine. I don't understand why it works in Power Point and not in Excel.

Thank you for your help.

A:Excel-Printing Text that was added to a Chart using the Drawing Tools "Text Icon"

When you select a chart in Excel, that becomes the print range. I think you'll be better off copying the chart to it's own worksheet and resizing to desired size...and of course, carry the text box(es) along with it.

Read other 1 answers

How do you turn on ALL of the drawing tools in Office 2003?


A:Turning on ALL of the Drawing Tools Office 2003

If their not there you didnít install them. Boot the Office CD and select Modify, select the options your looking for and load them.

Read other 1 answers

Hi, So this might be a very simple one, but it's been bugging me all morning.

um, i got a list of say about 600 sets of data. basically... a date(colum A), time of the day (colum B), and 5 temperatures points(Column C to G) that corresponds to the date and the hour. what i need is to find the average temperature of each of the the 5 points for a specific hour of each day. for example, i need the average temperature of all the temperatures of point 1 at 3pm in the afternoon. so the formula would draw every data in column C, that has a corresponding 15:00:00 in Column B, and then give me the average of all those numbers.

Any idea how to do it in 1 formula for each temperature point?

Thanks in advance.

Read other answers




A:Drawing in Microsoft Excel

Mumbodog, so what? Yeah, it is something that can be done, but that link teaches nothing - and the purpose of this branch of TechGuy (imho, at least) is far more learning and teaching oriented.
Move it to the Community or General Tech.

Read other 2 answers

Hi, I have drawn a scatter graph in Excel 2010. Now I want to draw another different graph on the same chart. How do I do this?

A:Drawing graphs in Excel 2010?


Read other 2 answers

I have been using P51s for the last couple of months. I have a strange problem with Excel graph drawing. The box of exis selection elongates out of screen as shown in the attached print screen photo. I use Windows 10 and Microsoft Office Professional Plus 2016. I have updated all the drivers, but the problem is still there. This is the only problem I have with the computer so far. I wonder if anybody has similar problems. Recommendations are very much appreciated. Zaf65 

Excel problem.png ?701 KB

Read other answers

I'm trying to draw a series of text boxes that will be lined up on top of each other (have to be text boxes) Is there some way to do it in one step...as in like a Table set up? I can't use Word and Insert Table because I need to write text to the side of the text boxes. Help!!!

A:Excel 2003 - Drawing Boxes

If I understand you correctly.....Highlight area on cells, the size of box that you want. Right click and then "format cells". Under alignment tab tick box by "merge cells". Then under border tab, apportion line you want round box. Then go to number tab and select "text" category. Then copy "merged" cells (right click, copy) and paste in cells below as required. Hope that helps.

Read other 1 answers

How do I divide a cell into 2 parts and separate it with a diagonal line ?

A:Excel - drawing a diagonal line in a cell

You can put diagonal lines into a cell in the borders section of the cell formatting.

However there's no mechanism for separating it into two distinct parts if you need the spreadsheet to work with the parts independently.
You might find this thread useful if it's just for presentation:

Read other 2 answers

Greetings and thank you for taking the time to read my plea for help.

In an Excel 2003 spreadsheet I have columns of data sorted by date. I have a vision of users being able to enter a start and finish date and at the click of a button have a graph drawn displaying the data from the date range the user entered.

I have managed to design a graph that will auto-update from an expanding range of data so I believe that all I now need is a way to copy the data from the specified date range into an area designated as the source range for my graph. Am I on the right track or is there a better way?

If I am on the right tack then how do I copy and paste the data from the date range specified by the user all with a single click of a button? The end users of the spreadsheet will be 100% computer illiterate hence the need for simplicity.


Read other answers

I drew a simple Excel drawing and it looks fine in Excel, but when I import it to my Powerpoint preso, the simple circles look wavy. and the lines look a little broken up. it looks fine on my PC, but when I view preso on laptop, that's where it looks funky.

Read other answers

I have a Autocad 2000 drawing with an imported Excel table, this table prints out on the laserjet printer but not on plotter. On the plotter where the table is just blank.


A:Autocad 2000 drawing with an imported Excel table


Have you tried this patch:


and it says:

Plotting monochrome OLE objects, such as a Microsoft Excel workbooks, while reducing the right-click OLE object plot quality to "Line Art" may improve the quality of objects plotted using the raster plotting mechanism. If a driver that supports the raster graphics pane in the PC3 Editor is used, sliding the "Balance" slider to the right now improves the resolution of OLE objects that are plotted to the raster path. Click to expand...



Read other 2 answers

I have a weird problem I need help with. I am doing some work and have been given data in a word document like so:


its not in a table and there is over 400 lines of it! I need to put this data into excel so I can sort through it. if it was in a table I could do paste special to place each bit of data into a different row.

Can anyone tell me if there is a way to either:
place the data into a table
copy the data correctly into excel


A:Solved: drawing a table around data in word or copying to excel

Read other 6 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'm trying to install Visual Studio 2013 on Windows 7 x64 and run into the same fatal error about 2 min in everytime: Build Tools x86 Fatal Error during installation.

I have attached a zip file w/ the screenshot of the error and the error log if it helps. if theres any other logs or info that might help shed more let i'm happy to gather those as well! any help would be greatly appreciated! I'll also say that I have been able to use the same install files on a different machine w/ out an issue so it seems as though the media isn't the culprit here.

thank you!

A:Visual Studio 2013 installation failed: Build Tools x86 Fatal Error

one more update to this.....i found this build tools log with a couple of possibly relevant errors that I was hoping could help. I just am not sure how to proceed...any help would be appreciated!

Read other 1 answers

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


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

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

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

Read other answers

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

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

Read other 7 answers

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

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

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.


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

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.
select 1 and populate a,b,c,d
select 2 and populate e,f,g,h
select 3 and populate I,j,k,l
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

I have a g700 laptop and wants to know why F4 & F2 doesn't work as usually with Excel 2013
Is there any possibility to find the same functionnality as I had with Excel 2010 before ?
Thanks for your quick answer 
Moderator Note; subject edited.

A:G700 f4 problem with Excel 2013

Hi alainbrizault,
Welcome to Lenovo Community Forums!
I?m glad to inform you that the F4 & F2 will perform the same functions in Excel 2010 as well as 2013, below are links to check the Keyboard shortcuts in Excel 2010 & 2013:

Keyboard shortcuts in Excel 2010
Keyboard shortcuts in Excel 2013

Do post us back for further queries.
Best Regards

Shiva Kumar

Did someone help you today? Press the star on the left to thank them with a Kudo!If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.Follow @LenovoForums on Twitter!

Read other 9 answers

how to email a excel sheet or excel workbook direct from excel ?tell me the steps.. all of excel 2007,2010,2013.

A:help about excel 2007,2010,2013 all.

Send as an Attachment>

will send the work book , which will use your default email client on the PC

Read other 2 answers

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


I am trying to tie one cell into a formula that is being pasted into multiple rows.
I know you can use $ to keep the cell consistent but it doesn't seem to be working.

So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.

A:Excel 2013 - how to keep a formula consisten

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

Read other 2 answers

Hi, the problem is like this, worked in the Excel spreadsheet before closing saved, turned off the computer. Resuming work in the program it turned out that was gone, all the formulas again, before exiting the program kept((( prompt please, whether probably to recover the data?

A:Failed to start MS Excel 2013

Hi , try to restore using the backup. if this does not help try .xls files repair, you will find him here

Read other 1 answers

I was wondering if anyone knows a cure all or a way to fix Office 2013 excel from freezing up.  MS is useless LOL, I have re installed and repaired several times.  I can do a simple cut and paste sometimes or even just want to add a coulmn and it locks up and reboots

A:Office 2013 Excel freezes up way too often

How much RAM do you have? I didn't see your system specs.

Read other 8 answers

Does anyone know how to do this?

A:How to Normalize data in Excel 2013

Define "normalize".
even better. Take a screen shot of what you see and explain what it is you want.

Read other 1 answers

Good times of the day ,
I have excel 2013 installed on win8 and i have several excel files on the internet that i try to open simultaneously and here is the problem: sometimes when one file is open and i try to open another it doesn't open until I close the first one. Does anyone have a clue or is this not a proper forum for office 2013?

A:excel 2013 problem on win8

You storing the files on Skydrive? That may be how it works, copy all of the files you need to work with locally, then you'll be able to open them all at once. I think Ofice 2013 gives you one file from a cloud service at a time, thats how most of them work.

Read other 2 answers

Does anyone know why when I try to save some Spreadsheets in Excel 2013 I get a message saying there is a sharing violation and I have to save the file under a different name.

I am the only person using the computer and the Excel program.

Thanks in advance


Read other answers

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

Iím in the process to make an Excel (2013) contacts address workbook and have all my contacts in Excel now. I would also like to have some kind of a V-card to be able to input new contacts and view existing ones. A typical V-card could be like the one I downloaded from here


I can make my own V-card but the problem I have is how to integrate the V-card to interact with the contacts database I now have.

Anyone can give me some help or perhaps provide an existing template?

A:Solved: Excel 2013 Contacts DB

Read other 16 answers

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


Please see the attached pic.

In the workbook I am working on in the pic there are 3 pages

page 1. is what looks like the main document that is worked in and it has a drop down menu that I would like to add vendors to a preexisting list (but I can not figure out how)

page 2. is a list of venders mot NOT all of which are in the drop down menu already (if I edit the list the changes do not effect the corresponding vendor that are already listed in the dropdown menu on page1)

page 3. named "sheet 1" seems to be blank and have no function

** in the picture you can see that I highlighted the "VENDOR:" drop-down and right bellow that I am showing the data validation for that drop-down.

I would really like to be able to edit this drop-down list.

Can someone please point me in the right direct?

Let me know if you need any further information!

Thanks a million!

Read other answers


We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

Now we have several columns that keep changing it's cell properties. For instance:
Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

Does anyone have an idea what could be causing this?

Thanks in advance,

A:Excel 2013 cell properties

Read other 13 answers

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

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

Read other answers

Running Windows 8.1 and Office 2013. Have a Canon 4370dw Laser Printer connected to my desktop via USB. Have a Brother MFC-J475dw inkjet connected wirelessly to the network. Default printer is the Canon. Here's the problem:

Word - In print dialogue, I can choose to print from either the Brother or Canon with no issues
Notepad - Same. Can choose whichever printer I like
Excel - Can see the Brother printer and it's online. When I click the Brother printer to select it, the Canon stays selected. It simply won't switch to the Brother although the printer dialogue box appears exactly the same in Excel as it does in Word.

Have run printer troubleshooting. Have re-installed Brother drivers and software. Have searched the web for a solution or someone that has had same problem. No luck. Any suggestions on what I can try next or what the problem might be? I'm surprised since I'm assuming that Word and Excel use the same printing module / dll.


Read other answers

Upon opening Excel Office 2013 instantly it configures my Aero setting to BASIC in Windows 7 Professional and then when you close the exit Excel it reverts back to AERO, what gives?  Can this be fixed?

Read other answers

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

Some of my .xlsx files denied to open. One of them showed an error message: File format not valid. Another file not so important how first one. Has somebody know Excel repair ways for my file? Many thanks for everyone?

A:Excel 2013 file issue

I have also had Excel issues in Windows 8 and 10 with Office 365 and know others have, too. An online repair has helped me. Go into the control panel click programs/uninstall and select Office 365...change...online repair. If you have another version of Office let us know. 

Read other 2 answers