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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
conditional formatting by reno
on a amotization sheet that may run to 240 payments, payments may start in any month and the first payment would be in about row 40 or so. want to highlight...
June 13th, 2004 11:49 PM
by Domenic Go to last post
1 309
VB to filter a list by CrankyLemming
Hi I have a worksheet containing a list of businesses, their addresses, phone numbers, and so on, and also a column which specifies the type of organisation:...
June 13th, 2004 10:56 PM
by CrankyLemming Go to last post
4 381
merge and wrap by David Fore
I'm formatting an excel spreadsheet. I'm using merge horizontally to get comments spread across multiple cells. I.E. name ______ comapny _______ date...
June 13th, 2004 10:22 PM
by Ragdyer Go to last post
3 361
MATCH within INDEX question by Ron H
Hello, In a previous thread I got a nice solution to a lookup problem I had with the INDEX/MATCH functions. I would like to learn exactly what the formula...
June 13th, 2004 07:15 PM
by Frank Kabel Go to last post
9 585
Bold deletion by Yarroll
Hi, I run a macro which checks if specific cells' font is bold. If it isn't, then the whole row gets deleted. The lines in question read: For k = howm To 2...
June 13th, 2004 05:10 PM
by Yarroll Go to last post
3 460
spliting words up by Continental Translations
In cells A1:A502, I have a few words in each cell. These words are split up by a colon. So, for example, in cell A1, it says "Today : yesterday", cell A2,...
June 13th, 2004 05:06 PM
by Ragdyer Go to last post
3 623
deleting spaces by Continental Translations
In a column of cells, tha majority of cells have spaces before the text. As there are over 500 cells, is there any easy way to delete these spaces? As there...
June 13th, 2004 04:54 PM
by Ragdyer Go to last post
2 506
summing based on auto filter by Art
I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...
June 13th, 2004 04:19 PM
by JE McGimpsey Go to last post
2 1,100
Lists obtaining additional information by engmgriff
Hi I have created a dynamic list. From this list I would like (depending on what the user has chosen) another list which represents the list they have chosen...
June 13th, 2004 04:17 PM
by JE McGimpsey Go to last post
1 468
Conditional Formatting by Art
In Excel 97, is it possible to have more than 4 conditional formats? Maybe up to 6 or 7. I am looking at changing the color of a row (say columns A through H)...
June 13th, 2004 04:14 PM
by JE McGimpsey Go to last post
4 647
Worksheets - Visibility by Doria/Warris
Hi, My Excel workbook has got many worksheets and in addition they have quite long names. As you can imagine, I have to scroll the horizontal bar continuosly...
June 13th, 2004 03:45 PM
by David McRitchie Go to last post
2 474
How do I run multiple instances of Excel? by Scott
In Word, each file opens in a separate instance of Word, with its own Taskbar entry, etc. But with Excel, if I click on a second .XLS file, it opens in the...
June 13th, 2004 01:40 PM
by Debra Dalgleish Go to last post
2 632
logic doubts by nowfal
I am using a work sheet for billing purpose, for that i need some security options for certain cells where i put currency rates, the format is as follows: A ...
June 13th, 2004 11:26 AM
by Aladin Akyurek Go to last post
3 370
VLOOKUP several conditions by Ron H
I have two worksheets, one with customer data and financial data, and a second with salesperson information. I need to "import" the salesperson from the...
June 13th, 2004 08:33 AM
by Aladin Akyurek Go to last post
6 569
On Open by Ian
Can anyone help me out with this? I want a worksheet to preform these actions each time it opens: Automatically unhide any hidded rows (especially...
June 13th, 2004 06:08 AM
by Frank Kabel Go to last post
1 397
Moving programs by greg
Can anyone advise how to remove a program from Excel to another program such as MSWord. I have a file that is incompatible with Excel.
June 13th, 2004 02:30 AM
by Gord Dibben Go to last post
2 357
Autofilter - are number of rows limited? by NickMinUK
I have a spreadsheet some 20 columns wide by 6000 rows. Autofilter has been applied to all columns on the header row and has been working without any problem....
June 13th, 2004 02:15 AM
by NickMinUK Go to last post
4 748
Automatic chart generator by Jon Peltier
Michal - I have some suggestions on this web page that would make it easier to select which data to...
June 13th, 2004 02:04 AM
by Jon Peltier Go to last post
0 608
WRAP TEXT by LYNN
I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE...
June 13th, 2004 01:42 AM
by JE McGimpsey Go to last post
2 527
Tab Fonts by
Does anyone know how I can change the font color on the worksheet tabs? Thanks in advance. Mike in Chicago
June 13th, 2004 12:57 AM
by Gord Dibben Go to last post
2 350
Post New Thread


Display Options
Showing threads 139701 to 139720 of 139764
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 04:41 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.