Question about Microsoft Office Computers & Internet
...the new work book.... present workbook select data/edit/copy new work book select cell edit/paste special/values now do the formating/color/font/size etc in the new workbook and check if they work ...
Question about Microsoft Office Computers & Internet
...formating a spreadsheet. I need column "a" to reflect the time it take to solve a query, if its longer that 03:00 to change colour to red. if the query is complete for the column to have no colour. I ...
...Excel.Copy-Paste converts into date format even when the excel sheet is ready to accept numbers. Thanks for help. [email protected] it should be =7/4 or =100/30 and excel will give you a numeric result. ...
...cells you want to copy the preferred cell to ----- by left clicking, the start cell (your courser will change to a large thick plus symbol) then hold and drag to the ending cell you want to place the ...
Question about Microsoft Office Computers & Internet
...copy 395.4 and paste 395 two options - 1st format the cells where you will paste (e.g. highlight one column - "the paste to column") by right clicking and choosing format cells, then number and set ...
Question about Microsoft Office Computers & Internet
copy pasted something to an excel worksheet but the auto sum doesn't work. can you help please? Its hard to know the issue, but I suspect its due to the cell formatting not being something that can be
Question about Microsoft Office Computers & Internet
...excel I am putting together a spreadsheet that will tell me when I need to re-order inventory. So if in column A, the re-order number is 4, then in column B (where I have stock in hand) I need it to ...
Question about Microsoft Office Computers & Internet
I had data on sheet one and for same the text format on another i want to copy data in the sheet having text format for particular cell reference which is there on first sheet Try using "Paste Special
Question about Microsoft Office Computers & Internet
...EXCEL 2000 corrupted workbooks/worksheets Have 2 workbooks approx. 4MB ea with 4 & 5 lasre worksheets. Am experiencing "cancerous" symptoms, incl 1) formats change on own, expecially which cells or ...
Question about Microsoft Office Computers & Internet
cells instead of their calculated value", or you can jjst press Ctrl + ` This will either turn on or off the show formula option. My first thought was also Tools/ Options/ View Tab - Formula - Uncheck
944 questions posted
Usually answered in minutes!
7,277 Questions
239 Questions
265 Questions
207 Questions