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
Excel - decimals by school girl
While using Excel, I find that the system isn't rounding appropriately to whole numbers - i.e., 84.5 becomes 84 - when it should be 85. Any help would be...
April 20th, 2010 08:37 PM
by Joe User[_2_] Go to last post
3 319
How do I set home to A1 instead of K1? by Julie D[_2_]
If I press the home key on an existing spreadsheet, it goes to K1 instead of to A1. Is there a way I can fix this? If not, do I have another possible...
April 20th, 2010 08:33 PM
by Gord Dibben Go to last post
2 357
Macro to hide rows with zero in specifc column range by David
Hello I have a workbook with multiple sheets. I would like to put together a macro that will hide the rows in a given range on all sheets. For example,...
April 20th, 2010 08:10 PM
by Luke M[_4_] Go to last post
1 368
Pasting a value as an hyperlink by The Rook
I have imported a list from a database of file paths to documents on our server, these data is currently formatted as 'General' Is there anyway of converting...
April 20th, 2010 08:05 PM
by Pete_UK Go to last post
1 225
making a correction in a row of excel? by patty davis
please advise
April 20th, 2010 07:50 PM
by FSt1 Go to last post
2 181
worksheet change question by Tonso
As I scroll across a particular spreadsheet, I would like to have the following columns change width, and zoom, as shown in the code below. However, the...
April 20th, 2010 07:17 PM
by Luke M[_4_] Go to last post
1 202
Cell colour in relation to IF results by Rob
I want a cell to be coloured red if the result of a simple calculation is negative, and coloured green if the result is positive. Can anyone tell me how to...
April 20th, 2010 07:16 PM
by Eduardo Go to last post
2 235
Row Height variations from computer to computer on same workbook by Barb Reinhardt
I've been sent a workbook by a colleague and on his workbook, a specific row has a height of 13.8 (23 pixels) and on my machine it is 16.5 (22 pixels). ...
April 20th, 2010 07:06 PM
by Barb Reinhardt Go to last post
1 222
Format Date Filter Problem by Stross002
I formatted a date from 4/20/2010 to April-10 I still have a hard time filtering my data. Eventhough it says April-10 it is still reading the day because...
April 20th, 2010 07:01 PM
by Ron Rosenfeld Go to last post
1 190
PROTECTING CELLS by LOCKING CELLS
I am having trouble protecting some cells. I mark all the required cells to be locked, then apply the Protect to the spreadsheet. Some cells are locked and...
April 20th, 2010 06:42 PM
by trip_to_tokyo[_3_] Go to last post
2 222
Excel 2003 Pivot Formatting by Bob[_53_]
On my pivot table i have formatted the sub total rows as "bold" and "aline right". Each month fresh data is dropped into the base table, so long as the number...
April 20th, 2010 06:27 PM
by Bob[_53_] Go to last post
2 164
Options saved with the worksheet? by Eric
Under tools/options, are the options saved with the worksheet, or do they apply across-the-board for all files that the user is working on? If I set an...
April 20th, 2010 06:22 PM
by John Mulford Go to last post
4 172
Excel - Run Macro on Cell Change by Malaria Man
I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I change...
April 20th, 2010 06:10 PM
by Don Guillett[_2_] Go to last post
3 245
Left Function by AJ[_10_]
I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such...
April 20th, 2010 06:01 PM
by Mike H Go to last post
1 203
Pivot Table Wizard in 2007 by Jane N[_2_]
I've recently started using Office 2007. I have 3 pivot tables that I need to update the data source each month. I was able to do this through the options...
April 20th, 2010 05:52 PM
by Roger Govier[_8_] Go to last post
1 222
Excell 2007 will not open XLSX by Burch
Has anyone run into this problem( excel will not open XLSX files on double click) the icon has changed into blank page with the excel ion in the middle of...
April 20th, 2010 05:41 PM
by Burch Go to last post
0 179
Insert Object Problem by Raj
Hi All, I inserted a PDF as an Object into Excel sheet . Now I see the PDF page in my Excel . But When I try insert a Text Box over the PDF image , the...
April 20th, 2010 05:18 PM
by John Go to last post
1 196
calculation help by Norm
I will try to explain this I want to have a running total for C D F and G and use the numbers in A as a filter so if I filter the numbers = 33369 I want the...
April 20th, 2010 04:58 PM
by Fred Smith[_4_] Go to last post
5 198
Sorting PivotChart by DogEatDog World[_2_]
Hi, In excel 2007 I want to sort data in the chart I made from pivot. I want them to be sort in descending order. The reason is, I need bar Pivotchart...
April 20th, 2010 04:41 PM
by DogEatDog World[_2_] Go to last post
0 164
Sorting Pivotchart by DogEatDog World[_2_]
Hi, In excel 2007 I want to sort data in the chart I made from pivot. I want them to be sort in descending order. The reason is, I need bar Pivotchart...
April 20th, 2010 04:40 PM
by DogEatDog World[_2_] Go to last post
0 196
Post New Thread


Display Options
Showing threads 2021 to 2040 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 03:39 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.