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
changing case by sos-DC[_2_]
I have a database of over 1,700 line in which more than half have addresses in ALL upper case. I need an easy way to change MAIN STREET to Main Street...
(Multi-page thread 1 2)
November 19th, 2009 08:50 PM
by sos-DC[_2_] Go to last post
10 168
if formula? by Jim
Hello, In A1 I will have one of the following number: 0, 1, or 2, which represents the number of clients lost. In cell B1 I have the text "0 Clients...
November 19th, 2009 08:44 PM
by Mike H Go to last post
2 98
Redundant Conditional Formatting In Move From 2003 to 2007 by KMH
I have an Excel model that after I moved it from 2003 to 2007 has a lot of redundant conditional formatting rules. Some conditional formats moved fine,...
November 19th, 2009 08:32 PM
by KMH Go to last post
0 116
Clicking on the Ribbon by Rich
I have a user, who, when in Excel 2007, needs to click on some buttons twice to make them work. This is not a "double-click" as we are used to. For instance,...
November 19th, 2009 08:28 PM
by Rich Go to last post
0 140
EXCEL: Separating data from 1 cell into multiple cells by HeatherJ
I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | ...
November 19th, 2009 08:04 PM
by L. Howard Kittle Go to last post
5 125
addition, subtraction in a single cell formula by mePenny
I need help updating a single cell formula. G4 has a formula of *=12500-A7 I would like to update this so that A7, A8, A9 are added together then subtracted...
November 19th, 2009 07:59 PM
by mePenny Go to last post
4 148
Pivot Table percentages by Timbo
I am trying to create a pivot table to show marketshare percentages, essentially I need to show the number of transactions in a pivot table as a percentage...
November 19th, 2009 07:57 PM
by Herbert Seidenberg Go to last post
1 156
Still in need of help by mePenny
I posted this prior with no final answer to my question. I'm looking for a formula that can help sort calendar from fiscal year. I'm hoping this is enough...
November 19th, 2009 07:52 PM
by mePenny Go to last post
3 127
How do I reactivate "Save On Exit" in Excel 2007? by Tom Edelbrok
How do I reactivate "Save On Exit" in Excel 2007? It seems to have been turned off somehow. Thanks, Tom
November 19th, 2009 07:39 PM
by Bob I Go to last post
3 103
changing "case" of letters by sos-DC[_2_]
I have a huge database in excel. Unfortunately, some of the entries are in ALL CAPS (E. MAIN ST or JOHN SMITH) It is unfortunate as they need to be E. Main...
November 19th, 2009 07:27 PM
by Francis Go to last post
4 146
Printing Problem by oceankayakjim
I have a one page Excel file that when I use Print Preview it cliams that there are 19 pages. Is there a way to fix this? Thanks for your time. --...
November 19th, 2009 07:25 PM
by Shane Go to last post
6 102
Menu options is on auto hide. How I turned off this? by Charlie
The menu on my Excell sheets is on aito-hide. How can I turned this off?
November 19th, 2009 07:23 PM
by Gord Dibben Go to last post
2 144
Alt + Ent No Longer Creates Line Break Within Cell by ChrsLvsBks
Good day, Until a week ago, I could use alt + enter to create a line break within a cell in Excel 2007. I am no longer able to do so. When I depress the...
November 19th, 2009 07:05 PM
by Gord Dibben Go to last post
2 149
Create read-only Excel file 2007 by Mary Ann
How do I create a normal read only Excel file in 2007? I’ve recently received a .xlsx file which is read only and I would like to be able to do this...
November 19th, 2009 07:05 PM
by Eduardo Go to last post
1 140
Column width by Emece
In Sheet 1 I have a certain amount of data, I want to select some cells and copy them to Sheet 2 keeping the same format. When I do this, the fonts and the...
November 19th, 2009 07:02 PM
by Jacob Skaria Go to last post
1 95
Urgent Help by XX23
Working on a word document with the links attached from Excel - Everytime I open or save the file, getting this error in Excel 2003 and drives me crazy - The...
November 19th, 2009 06:52 PM
by Gord Dibben Go to last post
3 124
transfer excel menu by Jeni
I'm having a different computer and need to transfer my customisations over to it. I know how to transfer my macros & toolbars but can't work out how to...
November 19th, 2009 06:48 PM
by Gord Dibben Go to last post
2 99
Action after save by PhilosophersSage
Is it possible to create an event after a save? I have a macro that runs before a save to hide specific sheets and would like those sheets available after...
November 19th, 2009 06:42 PM
by PhilosophersSage Go to last post
3 133
Can't stop the Update Links? startup prompt by Oddjob
I have an Excel workbook that resides on a network drive for many users to access with links to another workbook. I wanted to turn off the "Update Links?"...
November 19th, 2009 06:31 PM
by Oddjob Go to last post
0 95
Count Distinct by Johnny
I've scanned through related posts with no luck. I have a production spreadsheet with several columns of data. Here are the relevant columns (3) for my...
November 19th, 2009 06:29 PM
by T. Valko Go to last post
7 154
Post New Thread


Display Options
Showing threads 9741 to 9760 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:39 AM.


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