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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Filter and save result by annoni
After filtering a list, how do I save only the filtered result "as it is" on the same sheet and discard the rest? Please help...thanks.
May 28th, 2008 03:44 PM
by Peo Sjoblom Go to last post
3 242
missing Active Window bar by Gomer Fackworth
Apologies if this is not the correct forum for this problem. While not a new Excel user, I am new to OF. Recently I downloaded an Excel file with a list of...
May 28th, 2008 02:23 PM
by Gomer Fackworth Go to last post
6 334
What formulas to use for logic in excel by Kimber
I have two excel files. One file has vendor number and vendor name. The second file has vendor number and payment information based on vendor number. I...
May 28th, 2008 12:03 PM
by Niek Otten Go to last post
1 234
New Data Query Wizard by Octet32
In Excel I am trying to connect to a database using the New Data Query Wizard When I get to the choose Columns screen and click on the Available table and...
May 28th, 2008 11:50 AM
by Octet32 Go to last post
0 162
An Excel Formula know how to re-arrange the data by wilchong via OfficeKB.com
The 2 data sets are assumed running in A3 and in B3 down, viz.: In A3 down is: A, B, C, D and E In B3 down is: 35, 45, 13, 8 and 3. The result which I want is...
May 28th, 2008 04:29 AM
by T. Valko Go to last post
7 279
Newbie Question... by Benjamin M
I'm using Excel 2003. I can create columns, rows, data, new worksheets, etc., so I have a very basic knowledge of using Excel. With that said, here is what...
May 27th, 2008 04:45 PM
by scubadiver Go to last post
6 244
"office 12" excel and split-panes - how? by Ogg[_2_]
Anyone here familiar with "Office 12" version of Excel and how to enable split-panes? I''ve been trying to coach a friend via email on some Excel features...
May 27th, 2008 04:25 PM
by Niek Otten Go to last post
1 184
Forms by ginger
Have added form to website (http://sandrahand.com/gourmetclub/becomeamember). Host is godaddy.com; have installed frontpage extensions (deleted and...
May 27th, 2008 01:26 AM
by ginger Go to last post
0 210
delete info from source file w/out changing the destination file by TB
Hello I have two work sheet linked together for patient tracking files. All the information from the open source file is automatically updated in the Closed...
May 26th, 2008 06:26 PM
by TB Go to last post
0 217
What happens if you put "+" before a formula? by AB
I'm unable to understand what use a "+" sign has if it is put before a formula. For ex: +(C13*(1+$M$10)+J13)/(1-$M$12) gives the same result as...
May 26th, 2008 09:42 AM
by Sandy Mann Go to last post
1 229
Trying to change the background of a cell if I type a certain word by T-DOGG01
I am creating an Equipment Status worksheet for my job. Is there a formula that I can use to change the background color of a paticular cell if I type the...
May 25th, 2008 10:30 PM
by T. Valko Go to last post
1 239
Does 2007 have "edit points" feature, as 2003 did? by durkbarn
I am using MS Excel 2007, the draw function. I have some freeforms and curves that I must modify, but can't find the equivalent of 2003's "edit points"...
May 25th, 2008 09:26 PM
by ShaneDevenshire Go to last post
1 238
Increasing easily the number in a cell. by DB.
I have a very large number (8 digits, perhaps) in a cell and wish to increase marginally that number (add 2, say) without re-typing (almost) the entire string...
May 25th, 2008 01:46 PM
by Brad Go to last post
8 248
conditional formatting by KRK
Hello, I have a spreadsheet with several rows of data. The first cell of each row contains a logical formula which equates to 'TRUE' or 'FALSE'. I want to...
May 25th, 2008 01:35 PM
by Robert Martim, Excel Go to last post
1 250
Possible formulas by MissFitToys
What I want it to do is I have a drop down list in cell D3 that will display a name such as smith I want cell E3 to display a number such as 200 is this...
May 25th, 2008 04:02 AM
by T. Valko Go to last post
2 183
keyboard shortcut to return to previous cell after "find" or "got. by Nadavb
Is there any easy way to returnt to the previously selected cells? This is helpful especially after "goto" or "find".
May 25th, 2008 01:39 AM
by Dave Go to last post
1 219
Keeping Rows on the screen? by trvlnmny
I have used the first couple of rows as 'headers'. When I want to print this spread sheet I have set up the options so that these rows are repeated on every...
May 25th, 2008 12:11 AM
by Gord Dibben Go to last post
1 168
Limitation of Conditional Formatting by wilchong via OfficeKB.com
I use Conditional Formatting a lot! However, it only allow three conditional formatting for each cell. In my case, I need 5 conditional formats some...
May 24th, 2008 09:35 PM
by Learning Excel Go to last post
8 235
Help, please, with unwanted fill color by SedonaBob
Why does my entry into a cell result in an automatic fill color when the font selection is "no fill" and no Conditional Formating rule results in that cell...
May 24th, 2008 09:19 PM
by Gord Dibben Go to last post
3 139
Office 2007 Professional by AndyS
I have just installed Office 2007 and I am having problems finding the options that used to appear on the Tools tab in Excel 2000. Can any one help? Thanks.
May 24th, 2008 12:57 PM
by Bernard Liengme Go to last post
2 220
Post New Thread


Display Options
Showing threads 3721 to 3740 of 13737
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 02:43 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.