|
|
Excel 2003 - Footer Left/Right Margins by
Laura J
How do I change the left and right margins of footers (Excel 03)? Excel
seems to only allow distance from bottom of page as a margin, so I now have
footer...
|
|
3 |
208 |
|
|
Randomized Functions by
Kleverton Silva
how do i do to make Excel to generate random numbers to 30 persons?, but one
detail, no repeated numbers! i tried the "=Randbetween(1;30)" but i couldn't
avoid...
|
|
7 |
208 |
|
|
Out of memory? by
JENNYC
Hi there! I have a very large workbook i am almost done creating and
just ran into a little hiccup: It locked up on me, telling me i have
no memory available...
|
|
1 |
208 |
|
|
|
December 4th, 2005 11:11 PM
by Ray
|
4 |
208 |
|
|
Static Header Row by
Andrew Chalk
How do I make the top row of a spreadsheet a "nn-scrolling" header row?
Many thanks.
|
|
7 |
208 |
|
|
Macro to hide blank cells in a range by
Dave
I have an input sheet that has multiple cells for data input. Not all cells
are used on a monthly basis. I go through and hide the rows with blank...
|
|
1 |
208 |
|
|
|
|
1 |
208 |
|
|
prices by
Manager that needs help
I'm trying to do something simple. I want to compare prices from different
vendors: Column A = vendor 1, Column 2 = vendor 2, etc.. All of them have
different...
|
|
7 |
208 |
|
|
Problem using Advanced filter by
anandmr65
Hi,
I require to use advanced filter options for 3 times opening different
files. When I use the advanced filter for first time it works, but when
I open the...
|
|
1 |
208 |
|
|
How can I customize Freeze Panes in Excel? by
CraigD
I would like to keep row 1 on the screen at all times (column A through
whatever column can fit on the screen display - column O in my example)
without it...
|
|
3 |
208 |
|
|
|
|
1 |
208 |
|
|
How to refer to every 5 th cell? by
R.P.McMurphy
I'm currently working with this array formula...
=SUM(IF(G4:BJ4C4,C4,G4:BJ4))*0.09615
How do i change this so that G4:BJ4 refers to every 5th cell staring...
( 1 2 3)
|
August 27th, 2005 06:13 PM
by RagDyeR
|
21 |
208 |
|
|
|
|
2 |
208 |
|
|
How to partially lock the cells in Excel? by
Locking cels in Excel
Hi,
I have developed a check list survey using Excel, however, my problem is
that I want to lock certain cells that contains questions such that other
users...
|
|
1 |
208 |
|
|
Insert Row before Macro Button by
Kieranz
How do I create a macro which will allow me to insert a row on top. Eg
I have data in C3..H10. Row C11..H11 is blank but cells are formatted
(general,...
|
September 30th, 2005 01:57 PM
by Kieranz
|
2 |
208 |
|
|
Custom Views by
GLT
Hi,
I have a an Excel File with data that is shared by different departments.
All data is stored on the first worksheet. I then set up Custom Views so
that...
|
October 21st, 2005 06:15 PM
by GLT
|
0 |
208 |
|
|
REQ: Columns to rows or Rows to Columns by
nonapp
Look, this is my first time to post in this group, and I can tell I'm
already waaay out of my depth compared to most of you, but there used
to be a product...
|
|
4 |
208 |
|
|
synchronizing the years for multiple dates by
Davidjd
I have many dates that I need to sychronize the year on. For example:
1/1/2001, 1/1/2002, 1/1/2005 all need to say 1/1/2005.
It's a long list of different...
|
|
2 |
208 |
|
|
|
October 26th, 2005 10:58 AM
by Max
|
3 |
208 |
|
|
macro to change data in inactive sheet by
Diana
My document has two sheets. I am trying to write a macro that will allow me
to change data in a second inactive sheet by selecting the radio button on
the...
|
|
1 |
208 |