General

Print Preview
Why is the print preview different than the excel sheet? -- jpd414 ... 5 Mar 2010 12:50

Date
I receive the following error when I copy a cell with a date from a page 1 to page 2, the error is #value!!, do anyone have an ideea what can be wrong. -- CARA ... 5 Mar 2010 11:42

Lost arrow functionality within Excel
How can I reset arrows to move one cell up, down, left, or right when I'm in Excel? I'm a Mac user, using Office for Mac: 2004 Thanks. ... 4 Mar 2010 22:33

Multiple numbers in a cell separated by a comma, need separate cel
Multiple numbers in a cell separated by a comma, need separate cells. Is ther a way to take the contents of cell A1 (contains: 192410, 192413, 90704, ....) and "separate" the data to individual cells (without entering manually)? Thanks. ... 4 Mar 2010 21:26

Custom filling of cells
Hi, I am filling cells with the formula HBL0052-77 and am wanting to fill the series down, but only change the number immediately after HBL, not the last number ie/ so the next numbers in the series would be HBL0053-77, HBL0054-77. Is there a way to do this? Thanks for your help! ... 4 Mar 2010 21:26

dashed line after print preview
Does anyone know how to clear the dashed line that appears where the page breaks after you click Print Preview and then close Print Preview and go back to Normal View? Thanks. ... 5 Mar 2010 07:14

Data from Web Excel 2007
I am trying to import a table from a website into Excel that automatically refreshes and can be used in formulas. I was successful in doing this with a currency exchange website, but am having difficulty with this website in particular: http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html ... 4 Mar 2010 20:18

time calculations
I need help with a calculating two time periods of a work day B2 = day of the month B3 = Time in such as 8:00 AM B4 = Time out such as 1:30 PM B5 = Time in such as 3:00 PM B6= Time out such as 5:00 PM I would like B7 to figure out what the total time in hours for this particular day of work. ... 5 Mar 2010 00:45

Editing Dates
When I enter March 2010 into excel it automatically changes it to Mar-10. I'd like it to stay the way I originally typed it in. I already tried unchecking the autocomplete in the advanced options but it didn't work. ... 4 Mar 2010 18:05

reduce size ribbon
How to reduce the size of the Ribbon icons ... 4 Mar 2010 16:58