Spreadsheet Related Problems & Solutions

512 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 512
[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. ...

123456789... ⇓»

Popular Tags


Ask Question