**[Solved] How would I remove text from the begining of data in cell?** *Summary*: I have a spreadsheet that comes loaded with data but before the company name, there's a line of text that has nothing to do with my purpose and I need...

**How to create an if statement for a validation list?** *Summary*: I have a spreadsheet that tracks students. On sheet 1 is the complete of students. On sheet 2 is a report. I need a formula for a dropdown that will l...

**If Qty is 1 copy cell and adjust Qty in Mac Excel 2011** *Summary*: I have a spreadsheet starting at A1. I just copy and paste the data into the spreadsheet but I have to copy and paste and adjust the Qty on anything o...

**[Solved] How to find a value** *Summary*: I am trying to create a spreadsheet that states out of 4 cells if 3 are >=100% i multiply by 75% if 2 are >=100% then i multiply by 50%...

**[Solved] Formula is returning the text format instead of date format** *Summary*: I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected. Here i...

**[Solved] automatically enable macros on excel spreadsheet start** *Summary*: Spreadsheet contains macros. On startup of any spreadsheet the macros are disabled. To activate macros need to select option before proceeding. I thou...

**[Solved] how to change year 2014 to 2015 on existing excel spreadshee** *Summary*: on existing excel spreadsheet with dates of 2014 need to change these dates to next year, 2015. Want to preserve all other existing dates and data. ...

**[Solved] How do I make an Excel 2007 worksheet work in Excel 2013?** *Summary*: I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fin...

**how to print a selection of an excell spreadsheet in windows** *Summary*: When I highlight a portion of a spreadsheet that I want to print then click on the print option, it does not give me the pane to chose the "selection...

**[Solved] Nested IF/AND Function in Excel** *Summary*: I'm trying to build a spreadsheet that will allow me to compute 2 variables and return a value from one of 8 tables. I plan to have the tables in a se...

**[Solved] How to keep number from showing formulated cells** *Summary*: I have an Excel spreadsheet that has formulas copied into them. Because of the nature of the formulas, a value is there all of the time even though n...

**[Solved] Excel VBA Add Data Validation w Named Range Error** *Summary*: Hi, I am creating an excel spreadsheet that I am adding checkboxes, formatting and a data validation list using vba. I am having issues with the Data...

**[Solved] How to create a percent formula in excel** *Summary*: I NEED TO KNOW HOW TO CREATE THE FORMULA FOR TOTAL SUM OF 1 CELL PLUS 20% VAT SUM OF SECOND CELL TO CREATE A VAT INVOICE WITHIN AND EXCEL SPREADSH...

**[Solved] excel 2010 how to freeze and unfreeze headers** *Summary*: I am working with excel 2010 spreadsheet and i will like to know how to freeze and unfreeze headers so i can see the heading as i scroll down my spre...

**[Solved] Search comes up with nothing** *Summary*: A good percentage of the time, when I try and search for something in the spreadsheet, it will tell you nothing found. I could be looking right at it...

**[Solved] Color changes to a cell using IF** *Summary*: Using a spreadsheet for scheduling, and if an employee is Part Time, should have 32 or fewer hours. Full time should be 40 hours. I want to color co...

**How to work out price per square metre - in Excel** *Summary*: Excel spreadsheet Widths across columns in centimetres Lengths down rows in centimetres Price per metre in separate cell Want to fill in sheet with pr...

**[Solved] How do I get blank cells ignored if no value in a cel** *Summary*: Trying to get a list of dates to insert the day (short version) into a spreadsheet, but if a date is not present I want it to insert a blank. Formula ...

**need to automate calender update on new line each day** *Summary*: I have a spreadsheet that pulls the latest stock price data for several stocks each day. this info is updated all day long as the price fluctuates. A...

**[Solved] How to expand codes in a mathematical operation** *Summary*: How do I...You have been helping me with my problem and I want to do more on my spreadsheet. I have a large spreadsheet with many rows and columns tha...

**[Solved] Combining partial text from 2 or more cells in Excel** *Summary*: I am currently trying to make a spreadsheet where I assign a ID to every set of data which I have. The ID is the first 5 letters of the last name foll...

**[Solved] freeze four panes in a single spreadsheet in excel 2007** *Summary*: I have a spreadsheet where top 5 rows form the header and are already fixed. The first column i.e A is already fixed. Now I want the row 371 to be fix...

**[Solved] how to change a date which in 16.07.14 to 16/07/2014** *Summary*: When i work in a spread sheet and copy dates from other work sheets, i could not change the dates which are in 16.07.14 to 16/07/2014 ...

**[Solved] Delete blank rows and columns** *Summary*: To reduce the size of a file. No mater how many blank rows or columns are deleted the spreadsheet shows more than 60,000 rows ...

**[Solved] How can I directly access a pdf on an external server?** *Summary*: We all know that we can open a pdf from a link on a webpage or in a spreadsheet or some other document. When we click the link, the pdf opens a browse...

**[Solved] How do i delete an unwanted box from a spreadsheet** *Summary*: THE BOX IS HAS 8 POINTS TO EXPAND AND A ROTATING BAR ON TOP IT KEEPS GETTING IN THE WAY WHEN I WANT TO AMEND A CELL ...

**[Solved] Excel Macro to Save File Named in Specific Cell** *Summary*: I have an Excel 2013 spreadsheet that develops hyperlinks for the user to click on to view certain files. However, I want to be able to give the user ...

**[Solved] Hyperlink in Excel to E-mail Saved on Network** *Summary*: Good afternoon. I have an Excel 2013 spreadsheet with a hyperlink to an e-mail that I have saved on our shared network. The e-mail is a draft done in ...

**[Solved] Can't add another page to an xlsx spreadsheet** *Summary*: I have nine pages in my xlxs document, when I go to add additional data, it won't set up another page ...

**[Solved] how can i track a due date on ms excel 2010 spreadsheet** *Summary*: I am trying to keep track of due dates on my spreadsheets. I have some dates that expire annually and the others biennially. ...