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 / New Users / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Create "a thing" that shows vba code running10 Nov 2007 11:35 GMT7
Is it possible to create "a thing" that shows for the user that some
vba codes are running?
For example, I have four vba codes and it takes a few minutes to
process, but the user can get confused if it is working or not.
Auto fill multiple worksheets10 Nov 2007 09:34 GMT5
I have created an Excel Workbook, made up of numerous Worksheets.  These
worksheets are used to record daily information, at various locations, for
bi-weekly periods.  One cell, ‘J3’ is used to establish the beginning date of
the period.  The first date of the period is ...
How to change default zoom Excel 200710 Nov 2007 05:19 GMT10
I have a large desktop and would like to change the default zoom to 75% when
I open a new spreadsheet.  I can't find where to do this.
I have Vista and am on a network.  I thought the secret might be to modify
book.xls or some default template but I can't seem to find it.  Any ...
Copy from one list to another in different time scales. Confusing?10 Nov 2007 03:22 GMT2
Would anyone know what type of code to use so that it copies 1981q1
into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and
copies the value there to paste it into Apr 1981, May 1981, and Jun
1981....
calculating pay rates for different times of the day10 Nov 2007 01:58 GMT4
hi there i am new to this so please dont shout at me,i'm using office 2007.  
i'm after an easier way for me to calculate my pay i work odd shifts crossing
over time zones.
what i'm needing is to be able to calculate different pay rates.
Hide column is empty, not including header (row 1)10 Nov 2007 00:27 GMT3
I'm lost on this one, but I'm sure there is simple macro code to do
this.  I need this in a macro as I'm massaging data that beyond
removing empty columns.
if creteria is not found10 Nov 2007 00:23 GMT5
I need help with two questions
I have the following
                   Column A
1 PASSAIC CNTY N J Callable 06/08@101
Cell contents?09 Nov 2007 22:23 GMT10
Is it possible for a cell to contain a numerical value,
which is used for various calculations, and an alphabetical
designator that prints but does not affect calculations?
Example:
long cell spilling into next cel09 Nov 2007 22:18 GMT1
I have a cell with about 30,000 characters of html code, I removed the
line breaks, but when I save the file, either as xls csv or to tab
delimited, then reopen, some of the characters appear in other cells.
How can I prevent this?
Function to display formula in specified cell09 Nov 2007 21:08 GMT2
I am trying to display in a spreadsheet,  the formula in an adjent cell. Any
suggestions?
EXAMPLE:
cell A2 contain formula:  =Mid(c3,5.2)
Replace Defaults09 Nov 2007 20:12 GMT1
I'm sure this is something amazingly simple that I need to change, but I've never come across it before and I can't find it in the
Help.
Whenever I pull up Replace, Match Case and Match Entire Cell Contents are automatically checked now.  How do I change this?
Thanks,
How can I assign a data for one cell from another fixed cell?09 Nov 2007 17:46 GMT3
I can assign data to one cell by put formular, for example: =H5.
But if I add a row, my cell will get data from H6, Excel automatically
modified my formular to: =H6
And now I want the data always come from =H5, no matter how many rows I add
Microsoft Excel09 Nov 2007 16:14 GMT11
I am quite impatient and would like to watch a tutorial on excel that takes
one through the basics to advanced spreadsheet management. soes such a thing
exist?
Doesn't anybody else have this problem with Excel 2007???09 Nov 2007 15:58 GMT3
Excel 2007 kicks into Autosave on my PC, and basically, the CPU goes to
100%, and Excel is unusable until autosave is done.  This actually is taking
5+ MINUTES!!!  Its a real hassle, drives me up the wall!  Cuts significantly
into my ability to get work done, when i have to ...
Would like an explanation of a formula:09 Nov 2007 15:52 GMT4
=("1/1/"&(IF(LEFT(DQ10,4)*1<20,2000,1900)+LEFT(DQ10,4)))+MOD(DQ10,1000)-1
The other day I needed a formula that would change a Julian date to a
calendar date, e.g., 2006031 to 01/31/06.  I googled the question and found
the answer, for which I am grateful, in a formula provided by ...
 
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.