目前分類:title (4957)
- Jul 25 Fri 2008 20:45
Pass The Formulas Please
- Jul 25 Fri 2008 20:45
How do you reference the logged on user name in excel?
I am making a template that sever users will be using this amp; I don't know how
to automatically put the logged in users name into the header. Can someone
- Jul 25 Fri 2008 20:45
Getting product name from other sheet to match
- Jul 25 Fri 2008 20:45
How do you extend the number of blank columns in a worksheet?
I have a large data set the needs about 800-900 columns in a worksheet. I
limit for columns in excel is a about 200-300. i dont need any more rows
- Jul 25 Fri 2008 20:45
special case of sumif
Hi all,
I am trying to do a sum but based on a substring instead of the entire
- Jul 25 Fri 2008 20:45
Count number of days between dates BUT IF null to current date
I have a question I'm hoping someone can help me with. I need to know how
many days an invoice was open.
- Jul 25 Fri 2008 20:45
Resize Last Row to Fill a Page Width
Is there a way to resize a row to fill up the rest of the page? I want to be
able to change colomns A-E to whatever I want, and then have column F be
- Jul 25 Fri 2008 20:45
I want to start Excel in Print Preview. What's the quickest way?
I want to start Excel in Print Preview. What's the quickest way?
- Jul 25 Fri 2008 20:45
quot;New Web Queryquot;
- Jul 25 Fri 2008 20:45
Tool bar Icons should get brighter when clicked several times
It might be helful if the icons on the tool bar would get brighter after
serveral uses making them easier to locate. This could be reset when the
- Jul 25 Fri 2008 20:45
Microsoft Excell '97
I am trying to combine my Access Database into Excell. The problem is when I
try to get the information out the Acces Database I am not able to find the
- Jul 25 Fri 2008 20:45
finding out the combination of letters!
- Jul 25 Fri 2008 20:45
Can someone help with this complex formula?
- Jul 25 Fri 2008 20:45
Merge
I have received a large treasures report that i have to plough through, but
there are merged cells. is there s quick way to unmerge these cells instead
- Jul 25 Fri 2008 20:45
Locking and Hiding Columns
I have a spreadsheet that I need to share without the user being able to
unhide certain columns yet still have the ability to enter data in the other
- Jul 25 Fri 2008 20:45
What buttons do I need to push in order to switch between sheets?
This reffers to the same work book.
- Jul 25 Fri 2008 20:45
look between 2 cells and give the value of only 1
I am trying to get one cell to look at 2 others, determine which one has a
value, and use that value. for example, d3 has no value, d4 has a value of
- Jul 25 Fri 2008 20:45
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?
I have inherited a problem. I work with two multiple worksheet workbooks.
The first workbook is the quot;masterquot; into which data from the second is pulled.
- Jul 25 Fri 2008 20:45
one step update
- Jul 25 Fri 2008 20:45
how do i set up repeating row/column titles in Excel?
i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.