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
Sorting Differences (Ex07 vs. Ex07(Compatibility Mode)/Ex03), HELP by MJ
I am totally beside myself with this sorting challenge, perhaps one of my peers out there has a workable solution for us. BACKGROUND: - We have several...
October 27th, 2009 07:28 PM
by MJ Go to last post
2 227
How do I toggle read only in Excel 2007? by Jellybean
In Excel 2003 I had a "Toggle Read Only" button that I found by clicking View Toolbars Customise File - the last button was toggle read only I...
October 27th, 2009 07:26 PM
by Jacob Skaria Go to last post
1 213
Averaging values by RUSH2CROCHET
Hello everyone: Hoping someone can assist... I have a spreadsheet which reflects copier meter clicks as reported from 1'08 through current day. My...
October 27th, 2009 07:20 PM
by Sean Timmons Go to last post
1 201
How do i reference an external workbook for data validation? by Dex
I have followed the Office Assistant guidance but an error message appears stating "you cannot reference cells in an external workbook". I couldn't make...
October 27th, 2009 07:13 PM
by muddan madhu[_3_] Go to last post
2 253
Retrieve first 3 words in a cell by KrispyData
I have an address field and I would like to create a formula to retrieve the first 3 words in the address. How can I do this? example: 1245 main street...
October 27th, 2009 07:00 PM
by Ron Rosenfeld Go to last post
6 151
Calculate workdays in a month. by YY san.[_2_]
Hi, I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This is format as numbers, not date format. How can I use NETWORKDAYS in B2 to...
October 27th, 2009 06:59 PM
by muddan madhu[_3_] Go to last post
4 182
"0" Values on Pivot Chart? by Ken
Excel2003 ... I have a Pivot Table returning some "empty" cells in the Data Section. This is ok ... However, when I create my Pivot Chart (Bar) ... these...
October 27th, 2009 06:58 PM
by Ken Go to last post
0 196
Can I fix the position of an object on the screen? by Bob Arnett
I have an object (just a box with some text) on a worksheet that I would like to stay in the same place on the screen when I scroll or page...
October 27th, 2009 06:46 PM
by Bob Arnett Go to last post
0 131
If then and more by JJP
Good Morning Everyone, I am in the process of creating an excel spread sheet that will be used to track student tardiness. To this point I am using the...
October 27th, 2009 06:46 PM
by Sean Timmons Go to last post
1 145
converting excel 2003 to 2007 file formats by XX23
I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in...
(Multi-page thread 1 2)
October 27th, 2009 06:44 PM
by XX23 Go to last post
18 486
Excel could not find the data ....check format by Sarah H Pearson[_2_]
Is there something about the data retrieved using Business Objects which causes "find" to fail. Even if I copy the data I am looking for from the...
October 27th, 2009 06:27 PM
by Sarah H Pearson[_2_] Go to last post
0 142
Can I use vlookup to do this? by Coeus
I have a sheet like below: aaa 1 bbb 2 bbb 3 ccc 4 ddd 5 ddd 6 ddd 7 Now I want to reorganize the table like below: aaa 1
October 27th, 2009 06:16 PM
by Jacob Skaria Go to last post
4 315
Format cell to always begin with an "X" by Cheri
Is it possible to format a cell to always add an "X" at the beginning of the data input in the cell? I imagine it can be done under...
October 27th, 2009 06:11 PM
by Sean Timmons Go to last post
2 230
Why can't I get more than 255 characters in one cell in Excel 07? by BigMan68
The Excel specifications state that you can have up to 32,767 characters in a cell within Excel 2007. When I enter more than 255 characters (which I can do)...
October 27th, 2009 06:09 PM
by Dave Peterson Go to last post
1 126
Can Excel enter page breaks to always follow a merge cell? by Paula Ohio[_2_]
I have 30 documents and want the page break to always follow a merged cell. I don't want the page break in the middle of the merged cell. I am manually...
October 27th, 2009 06:06 PM
by Bob I Go to last post
1 243
formulas, if/then by nan4ca
Is there a way to set up a worksheet so that if a condition is met in a cell then a formula will be performed in another? Ex.: If, in A1, the data is equal...
October 27th, 2009 06:05 PM
by Sean Timmons Go to last post
1 118
Inserting a Graphic on a Button when the Button is Assigned to a M by smck
I am working in Office Excel 2007. Inserting a Text Box from Developer Tab, Controls Section, Insert, allows you to insert a Text (Form Control) button to...
October 27th, 2009 05:46 PM
by smck Go to last post
2 156
Conditional List dropdowns? by GD
Hi, i'm looking to add a condition to certain list drop-down options based upon the selection in a prior dropdown, is this possible? For example dropdown A,...
October 27th, 2009 05:44 PM
by Jim Thomlinson Go to last post
1 139
If........then...... by nan4ca
Is it possible to create a formula that if a condition is met in a cell, then go to another cell and perform formula in that cell? For Ex.: If the data in...
October 27th, 2009 05:42 PM
by Jim Thomlinson Go to last post
2 210
How do I change the color of the cell pointer? by I Stevens
When I do a search of a particular entry, it's very difficult to identify where the cell pointer is because it's in black and I have gridlines on my...
October 27th, 2009 05:41 PM
by Bob I Go to last post
7 271
Post New Thread


Display Options
Showing threads 11001 to 11020 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 10:35 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.