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 / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
data, sort option is grayed. how to sort on a column?25 Sep 2007 15:25 GMT1
right click to select column. data menu. sort option is grayed. why?
( I thought it was because I had already sorted this spreadsheet. but
I created a new sheet, copied in a few columns of my problem sheet.
and I can sort on any column I choose to. )
How to i capitalize all words in an existing worksheet?25 Sep 2007 15:19 GMT3
I have a worksheet that contains approximately 2500 names.  At this time all
names in in lowercase.  I need to get them all into UPPERCASE.  I know
there's got to be an easier way to do that rather then retyping each name.
Copying the repeated data of the previous sheet to the next sheet25 Sep 2007 15:18 GMT1
I have a problem while exporting a data in an excel sheet.
The first time I have exported I got the data as mentioned in column A and
the relative data is manually entered as in column B
Sheet 1
fromula bar25 Sep 2007 15:09 GMT2
the formula bar in my excel program has a horizontal orientation but entered
data is presented vertically, making it difficult to read.  i have been
unable to find a way to change that.  thanks for the help.
how cani create a pop up reminder when closing excel?25 Sep 2007 14:59 GMT2
i want to create a pop up window so when i x excel, it pops up like an error
message. so it says 'did you remember to update total of customers' with a
yes and return button. Please help me :D
Wacky time calculation25 Sep 2007 14:56 GMT6
One of my data sheets at work brings numbers into Excel as decimals. For
instance, 5 hours and 39 minutes is shown as 5.39. How can I get Excel to
convert this to 5:39 (semicolin instead of decimal)?
Keeping Margins and Forcing Landscape mode on a shared Document25 Sep 2007 14:36 GMT1
I made a Excel Spreadsheet that is set to landscape and has a few adjusted
Margins.  I put it up our office Network but everyone else who opens it still
sees the old Margins and Portrait mode.  Yet if I open it, it's fine.  Any
idea how I can get everyone else to view it the ...
Matching Names listing Data from one Column!25 Sep 2007 14:20 GMT1
Hey all need some help!
Data Sheet 1
Conisits of Names from
B15:B49
Creating a Search Cell25 Sep 2007 13:51 GMT3
I have a customer list in column 1 from a4 to a500.  I want to be able to in
a1 type some letters and the customer corresponding to the letters i am
typing in comes up.  Exactly like a search engine for excel.  Any help on
this?
about this formula =DATEDIF(J5,H5,"d")25 Sep 2007 13:46 GMT4
i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE
How to retrieve data from other filename?25 Sep 2007 13:42 GMT1
Does anyone have any suggestions on how to retrieve data from other filename?
For example, the filename for my current workbook is Eric - RRRRR.xls, and
the cell A1 under sheet1 for Eric - RRRRR.xls workbook equals to the cell B2
under sheet2 for Temp - RRRRR.xls. And I get a ...
Prevention of Printing25 Sep 2007 12:20 GMT1
I would like to send an excel document to someone , it consists of
approximately 6 worksheets. Is there a way that I can prevent them from
printing it out once I have emailed it to them.
Any help would be appreciated.
if number occurs twice25 Sep 2007 12:14 GMT1
Good day,
If I've gat the same number showing up twice , can I get the name next to
the second number as well.
 A             B
Save As Functionality25 Sep 2007 11:34 GMT2
I have noticed that when i go to file - save as... and then select the drop
down list to select the drive i wanna put my .xls file into... that it takes
sometimes 3-4 minutes for it to drop down. This doesnt happen in any other
Office program. I am on a company network (fyi)
How to determine the top 5 occurrences from a list of numbers?25 Sep 2007 10:30 GMT3
Does anyone have any suggestions on how to determine the top 3 occurrences
from a list of numbers? For example,
1,1,1,1,1,2,2,2,3,3,3,3,3,3,4,4,5,5,5,5,5,6,6,6,6,7,7,7,7,7 under column A
The occurrence of 1 is 5 times
 
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.