A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
emailing protected Excel worksheets by R Maule
when attaching a password protected Excel worksheet to an email, the password protection is not transferring. have attempted using Microsoft Outlook with the...
September 17th, 2003 07:59 PM
by Ron de Bruin Go to last post
1 418
Multi worksheet data look up by Ray
I am looking for a way to copy data from multi worksheets to another worksheets. I have 50 worksheets of data and what to copy an area of data from any 1 of...
September 17th, 2003 08:02 PM
by Harlan Grove Go to last post
1 518
sumproduct variables by Tony
Hello Group, How do I include multiple cell reference variables in a sumproduct function? For example, if I wanted to include text values I would use...
September 17th, 2003 08:27 PM
by Aladin Akyurek Go to last post
7 436
Pivot Table Display by td
I have created a pivot table with the following parameters: Page Area = Customers Row Area = Product Column Area = Month Data Area = Sales $ When I select a...
September 17th, 2003 08:36 PM
by Debra Dalgleish Go to last post
1 275
MouseClick as Counter by David Webster
Is there a way to add code so that you add one to every cell you click on within a range? E.g. any cell between say C3 to H20 when I clik it I want it to...
September 17th, 2003 08:45 PM
by Andy Brown Go to last post
1 324
Formatting (General to Number) by Tom R
Does anyone know if there is a way to change the number formatting from General to Number in one shot? I have an entire column that is in general formatting,...
September 17th, 2003 08:49 PM
by Ken Wright Go to last post
5 1,017
testing by testypants
does this thing work????
September 17th, 2003 08:52 PM
by Harlan Grove Go to last post
1 397
Spherical Coordinates by Keith Ingstrup
Given: Radius, inclination(in degrees) and azimuth(in degrees). Can excel calculate P(x,y,z)
September 17th, 2003 08:57 PM
by Harlan Grove Go to last post
1 347
Excel database query by Jean
I am using Office 97. I recently moved an access database from one network drive to another. I have an excel database query to that database that no...
September 17th, 2003 09:03 PM
by Dave Go to last post
1 383
unhiding Column A - help! by Phil
I've run into an odd problem. I did a Hide on Column A and B. Excel won't let me unhide a column unless I highlight the columns on BOTH sides of it. I have...
September 17th, 2003 09:05 PM
by Don Guillett Go to last post
1 310
Data Validation by dinna
can anyone help me !!!! I am trying to create a drop down list in excel with data from another tab. Is this possible, if so how can I do...
September 17th, 2003 09:13 PM
by Debra Dalgleish Go to last post
1 288
Autofill formulas b/t various worksheets by lbenson
Hello- I have a workbook w/ 25 worksheets. I need to sum the same cell from each worksheet and put it on a separate summary worksheet. I tried to use the...
September 17th, 2003 09:15 PM
by RagDyer Go to last post
3 474
Pooled regression and dummy variables by Kev Summersgill
I'm a bit of a novice with excel. I have a dataset of national ststistics which only has a few years so I can't run a time series regression with any...
September 17th, 2003 09:16 PM
by Michael R Middleton Go to last post
1 697
trendline equations are incorrect by Fred
I charted a set of coordinates. The polynomial equation fit extremely well (r square = 0.99) Unless I'm doing something wrong, (and I don't think I am; I had...
September 17th, 2003 09:21 PM
by Michael R Middleton Go to last post
3 438
Custom Template Worksheet Location by brohar
I cannot for the life of me get my custom template worksheet to show up in the same location as the default xlt files. My PC is a company machine but my help...
September 17th, 2003 09:27 PM
by Radio848 Go to last post
3 499
Linking by Dawn
When doing a link to another program, borders are missing. Any way to fix this.
September 17th, 2003 09:33 PM
by Dawn Go to last post
0 263
Spreadsheet play file then close by Brenda
I need to create a workbook that will play a .wav file then automatically close. Is there anyway to do this without having "Enable Macros" dialog box pop up...
September 17th, 2003 09:43 PM
by John Wilson Go to last post
2 332
Copy subtotals by Erin Paulin
You just saved me a TON of work!! Thanks for the very helpful post! Erin -----Original Message----- If this has to be done often, there is an icon which...
September 17th, 2003 09:50 PM
by RagDyer Go to last post
1 679
Remove Spaces by Bryant Caldwell
How can I use a function to remove spaces from a string. Before Smith , Bob After Smith,Bob Thanks,
September 17th, 2003 10:05 PM
by Lynnus Go to last post
3 428
Worksheets by Walter Payne
My worksheet is long. How do I divide it and still have the information linked to the first page.
September 17th, 2003 10:06 PM
by Walter Payne Go to last post
0 236
Post New Thread


Display Options
Showing threads 181 to 200 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.