|
Help open Excel 2007
My Excel 2007 tries to open but closes immediately. I cannot open any files
in excel.
Please help.
Thank you....
|
3 |
11/16/2008 5:26:35 PM |
|
|
Excel: Reminder/Pop-up message
Hi Guru out there,
I would just like to ask for all of your help. I actually know basic from
Excel - I'm using version 2002.
I have an excel sheet, that has a column of " Termination Date " its date
format was 20081112(yyyy/mm/dd). Can you help me, on how to put a reminder
or pop-up message that I have termination date on or before 20081130 (Nov.30,
2008)?
Also, if possible to ...
|
8 |
11/16/2008 3:10:05 PM |
|
|
order of days
Hi everyone,
I have in A1:Ax dates, formatted as "mm.dd.yyy", i need a formula that
will tell me which day is that day, but in the known way like monday,
tuesday,.... i know how to do this, i want to get something like this:
FIRST Monday of December 2008, like getting the date and telling me
which monday of this month is it, or say second saturday, fourth
wednesday, such things i mean.
i ...
|
10 |
11/16/2008 1:01:58 AM |
|
|
How does an address appear to have 2 fields in 1 - see sample data
Hi-I recently learned Access and have created tables. I noticed that in the
sample Database provided (Norhtwind) they have a Customers Table that has an
address field. At first glance when reviewing a customer - "Consolidated
Holdings", you can only see the address of: Berkely Gardens; however, if you
put your curser after Gardens and use your arrow key, it displays 12 Brewery.
Also, ...
|
7 |
11/15/2008 10:12:02 PM |
|
|
date in wrong format
My mo/da/yr format somehow changes to a 5 digit entry - 393xx. I have tied
the normal procedure of format cells, date, etc. but that won't fix it. What
can I do? ...
|
4 |
11/15/2008 8:42:47 PM |
|
|
Stupid
When I go to open a file stored on the network "Network" is not listed by
default as a place to find and open Excel files in Excel 2007.
This is as moronic as the ribbon of abomination.
Yes, I can find out how to add "Network" as a default choice but it should
be their to begin with.
That, and the fact that Excel 2007 does not recognize conditional formatting
in spreadsheets created in Ex...
|
2 |
11/15/2008 6:28:34 PM |
|
|
changing the order of text in a string
Using Excel 2003, I have a column of names, in the format
John Smith
Henry A. Jones
Maryanne George
Mary Ann George
I need to reverse the order, to be lastname, firstname +middle(if present)
Thus I get
Smith, John
Jones, Henry A.
etc.
How can I extract all the characters starting at the right side, to the
first space, and move that to the left, followed by a comma.
Pepper
...
|
4 |
11/15/2008 12:17:01 AM |
|
|
how do I stop zoom on mouse scroll in EXCELL office 07?
I used to be able to use the middle "scroll" on my mouse in EXCEL to page
down, but now it only zooms! in our out.... I want to page down in the new
Office 07. how do I stop it?...
|
2 |
11/14/2008 8:27:01 PM |
|
|
divide so no error Excel 2007
I have a simple issue. I have two cells with numbers and I want to divide
one by the other and set it up on many cells. Problem is if I enter the
folmula befor there are actually numbers in the two cells I get the Divide
by 0 error (#DIV/0!)
So How can I divide A2 / B2 only if it won't produce an error?
...
|
2 |
11/14/2008 5:50:50 PM |
|
|
Automatically deleting macros
I recorded and ran a macro for the the first time and it worked beautifully
but I was suprised that I was not able to fing the macro to run it in a
different workbook. I saved the macro in my Personal Macro Workbook. Do
macros automatically delete or move themselves after they are run? Do I have
to save changes to the workbook the macro was run in for the macro to be
saved? Thanks in...
|
4 |
11/14/2008 5:14:41 PM |
|
|
todays date
How would I get todays date in an excel spread sheet
--
kaushi...
|
5 |
11/14/2008 1:22:43 PM |
|
|
I can't get my header to show up on every page, just the first
I can put a header on the 1st of my 3 page EXCEL doc, but the header doesn't
show up on the 2nd and 3rd pages. What am I doing wrong? Thanks.
--
Terry...
|
2 |
11/14/2008 12:20:29 AM |
|
|
AutoPopulate Cells
I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.
Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck....
|
6 |
11/13/2008 8:18:50 PM |
|
|
create excel spreadsheet for weekly work
I barely know excel. I have been asked to create a spreadsheet that will
rotate 8 people for an entire year. I think it can be done, but need to know
where to begin. I woudl also like this to be dynamic. If I input a new YEAR
then I want all the fields to adjust accordingly.
So for the first week of 2009 person A
for the second week of 2009 person b
and so on for a total of 8 people...
|
2 |
11/13/2008 4:26:18 PM |
|
|
How would I forecast something(sales) using excel
Can someone kindly help how to forecast. For and example lets say I ve got
sales data for the past 10 months. And I need to forecast sales for the next
two months. Also I was given the targeted amounts for the 2 months. I need to
fore cast sales by product to match the final target figure for the 2 months.
Is there a mathamatical way to do it using excel.
Help would be greatly apprecia...
|
3 |
11/13/2008 1:13:01 PM |
|
|
Linking documents (non-numeric information
Hi
I have been asked to create 2 documents -
1) A Vacation Schedule for the Trainers and
2) A Master Training Calendar of where, what and who will be conducting
Training
The challenge I am facing is creating a link with these two documents which
will allow simultaneous update to the Training Calendar about the status of
the trainer (ie if they are on vacation).
Can anyone offer a...
|
2 |
11/13/2008 7:01:01 AM |
|
|
How do I copy a word table into excel
I'm trying to copy a word table (contains multiple paragraphs) into excel but
excel breaks each Word cell into several rows.
Is there a way to copy a Word table into Excel cell by cell.
...
|
3 |
11/13/2008 3:46:00 AM |
|
|
Save As versus Save
I've created a spreadsheet that I need to make accessible to our managers.
They will need to open the form fill it in and save the new form with their
information. How do I force them to use the "Save As" command versus the
"Save"?...
|
5 |
11/13/2008 3:30:00 AM |
|
|
Data>Filter>Auto Filter in excel 2007?
I have Excel 2003, but oversee a large group that has Excel 2007 (just got it).
I can't find simple instructions on how to Auto Filter. Please help...
|
3 |
11/13/2008 3:28:05 AM |
|
|
excel chart/ word doc.
how do I fix an excel chart to fit my word doc. ?...
|
2 |
11/13/2008 3:20:02 AM |
|
|
Calculated values in a cell
Hello All,
I am trying to use this formula
=IF(AG3=5,"2008",IF(AG3=4,"2009",IF(AG3=3,"2010",IF(AG3=2,"2011",IF(AG3=1,"2012")))))
to assign a year value to the numbers 1,2,3,4, and 5. These numbers are the
product of the following formula:
=IF(AF3>2.6,"5",IF(AF3>2.01,"4",IF(AF3>1.42,"3",IF(AF3>0.83,"2",IF(AF3>0.24,"1",IF(AF3<0.01,"Beyond
5 Years")))))). When I write ...
|
6 |
11/12/2008 6:27:09 PM |
|
|
Split cell ascii
Is there anyway to split up a cell with several words and numbers to
automatically split before the number for a new column or comma
ex: the are going 123/45
split up = the are going, 123/45
...
|
3 |
11/12/2008 4:16:02 PM |
|
|
Insert a row after next 100 rows
d'all,
I hav a sheet of 5000 rows. I want to insert a blank row after next 100
rows. I don't want to insert row one by one bcz of time consuming. Plz give
me any solution for that....
|
4 |
11/12/2008 1:52:44 PM |
|
|
Drop down menu with validation that requires Marco
I try to create a form that contain two cells where cell 1 requires user to
enter information like A or B or C. I am able to use drop down method for
cell 1.
However, the cell 2 require certain validation that relate to information
that entered in cell 1. if User enter A in cell 1, then only the require
information like A1, A2, & A3 shall appear in the drop down menu, likewise if
us...
|
2 |
11/12/2008 7:15:01 AM |
|
|
how do I create a title for my spreadsheet. As in a headline?
How do I make a headline for my spreadshett? I'd like to center it at the top
of the page. Thank You....
|
2 |
11/12/2008 12:36:05 AM |