I have received a spreadsheet with columns numbered 1 - 4 to the left of
Column A1. They are locked amp; have a scroll bar at the bottom of the sheet.
目前分類:title (5957)
- Apr 21 Sat 2007 20:36
What are colums to the left of Column A for?
- Apr 21 Sat 2007 20:36
Creating a Rankings Table
My data comes in like so:
- Apr 21 Sat 2007 20:36
Don't know
- Apr 21 Sat 2007 20:36
i lost a file opened on top of another one
if you have saved over the feb one then theirs noting you can do to retrive
it,,,
- Apr 21 Sat 2007 20:36
Split data into new sheets
I have a (very) long list, sorted by account code. I would like to write a
macro that splits the list into separate sheets in the workbook, with a
- Apr 21 Sat 2007 20:36
how do i recover a consolidated worksheet that i sorted/subtotale
I had a consolidated worksheet from 01/01/05 to current,and was requested to
sort by name/date and then subtotal all entries w/o saving the consolidated
- Apr 21 Sat 2007 20:36
How to enter pre-decimal pounds shillings pence in Excel workshee
I would like to be able to enter English pre-decimal currency in an Excel
worksheet - i.e. pounds shillings and pence. Can anyone advise whether this
- Apr 21 Sat 2007 20:36
How do I enter the contents of a cell into a page header
Can I insert the contents of a cell into the page header or footer without
having to use a macro.
- Apr 21 Sat 2007 20:36
Tried HLookup, IF statement, but I need something more....
Hi,
I have a workbook with multiple worksheets. The first 2 worksheets are the
- Apr 21 Sat 2007 20:36
change year date
i have a data that has dates that show up as 4/25/200, 4/25/2020 and 4/25/200
- Apr 21 Sat 2007 20:36
RePost: Protect
I want to protect all the worksheets
however leave the pivot tables for Filtering
- Apr 21 Sat 2007 20:36
Excel caution, WHY?
not enough system resources to display completely
- Apr 21 Sat 2007 20:36
Search trhu whole document
- Apr 21 Sat 2007 20:36
Cannot be MERGED into the current workbook
I am getting the following message when attempting to Merge spreadsheets in
Excel 2002...
- Apr 21 Sat 2007 20:36
formula
In column J I have the following formula =IF(E7=quot;quot;;quot;quot;;J5 (E7-F7)/24) and
everything works fine, but my problem is that if a 0 is in column E then the
- Apr 21 Sat 2007 20:36
Using Vlookup in a string search of a cell
I want to search a cell in a report where supervisors report staffing
actions. When overtime is worked they may note it as O/T, OT or ot. I was
- Apr 21 Sat 2007 20:36
I am trying to match 2 lists
What I am trying to do is match 2 lists to get a value. In other words in
sheet1 I have this:
- Apr 21 Sat 2007 20:36
I need the cell to prompt me...
- Apr 21 Sat 2007 20:36
How do I insert pictures in excel with the correct aspect ratio?
I am attempting to insert scaled drawings into Excel copied straight from
Microsoft Documant Imaging software (.mdi) and Excel skews the drawing while
- Apr 21 Sat 2007 20:36
Excel's Compress Pictures or deleting pictures doesn't seem work
Adding images to an excel workbook (specifically, dragging GIFs from IE,
don't know if it also happens with File gt; Insert) always increases the XLS