Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Pivot table has bloted file size - how do I bring it down18 May 2007 13:20 GMT2
I have created an Excel 2007 which has 5 pivot tables with a common  data
source in another sheet within the same file. The data source is of only 500
rows or so with about 15 columns (i.e. not particularly large).
However while specifying the data source at the time of pivot ...
how to convert nos into word format say 500 to Five Hundred18 May 2007 13:02 GMT3
how to convert nos into word format say 500 to Five Hundred
We have huge data containing no's, would like convert the same into word
format
Example    to convert
How do I synchronise Excel files ?18 May 2007 13:01 GMT1
I'm trying to syncronise Excel files with my PPC.  Is there a way to set it
up so that I can append the information for both files with each sync such
that it doesn't matter which copy (PC or PPC) I update ?
Change Date Created18 May 2007 13:01 GMT2
Is It possible to change the date created on an excel file.
Someone's renamed a file and the date as refreshed to when they did it, but
I would like it to be the date the original was created.
Is this possible?
Formula to seek and find duplicates18 May 2007 12:54 GMT2
Need to know how to find name and address duplicates in a rather large Excel
file.
Are there any ready made formulas etc.....
spreadsheet stuck18 May 2007 12:50 GMT7
this is hard to explain but I have Excel 2003.  When I open a spreadsheet and
then click on a cell with my mouse, the "+" appears, highlights anywhere I go
on the page and I cannot get it turned off. can someone tell me how to get it
turned off?
change 04/02/07 to 04020718 May 2007 12:30 GMT2
How do I can the cell to display change 04/02/07 as 040207
Format of postcodes18 May 2007 11:40 GMT3
I have a column in a worksheet populated with postcodes. These
postcodes are either 6-character or 7-character strings.
Eg:
AB19PQ
another IF query ......18 May 2007 11:03 GMT23
How do I work this one out please?
IF 'A20' is not null AND 'A16' is null OR 'A17' is null then COUNT result in
'A14' on a different spreadsheet!!!!!
help me please ...........
active cell bold18 May 2007 10:53 GMT7
Im trying to make the active cell either bolded or highlighted. Is that
possible?
'If' Query18 May 2007 10:32 GMT3
Im developing a Time tracker spreasheet for my team.
In this i have some fields - 'Status', a list that contains {Office,
Holiday, On Leave} and Hours field.
At the bottom of the sheet i have columns - Total Utilized Hours, Total
vlookup to obtain pictures18 May 2007 08:38 GMT1
My problem is this:
Based on an employee number, I want to extract the job title and name from
two columns and their picture from another column.  I can extract the text
but I do not know if I can use Excel to store the pictures and use vlookup
check a row ignore blank cells print only those with text18 May 2007 08:32 GMT4
I want to check down a column of cells, some of which may be blank, I want to
gnore the blank ones and print only the contents (in another cell) those with
a number in them.
eg
rename worksheet based on contents of a cell in different workshee18 May 2007 06:02 GMT1
I have three worksheets within a workbook.  The three worksheets are named
"Account Info"
"sep 27,2006"
"lists"
Inserting?18 May 2007 05:16 GMT1
I'm a reasonably knowledgeable Excel user having had it since my old DOS days
when I ran it with a run time Windows environment.  I also know I'm not as
good as some power users I know that really amaze me with what they can do
with Excel.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.