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
shrink excel page to print out standard size by clara
I would like to print out an excel page on to a standard sheet of paper. Can not figure it out.
May 12th, 2010 12:17 AM
by Gord Dibben Go to last post
1 449
Must I use IRM to protect an entire workbook? by DonMark
I'm trying to protect an entire workbook so that the forumlae will be hidden from view. I would rather not protect each individual sheet, using a password...
May 11th, 2010 11:51 PM
by Gord Dibben Go to last post
1 272
Cell fill color in linked cells? by Scott
I am using a 2007 workbook as a Training schedule for a military command. I deal with various different military units and in order to quickly tell which is...
May 11th, 2010 11:43 PM
by Gord Dibben Go to last post
1 290
Vlookup with Multiple Rows to match with one row by Motaad
I am trying to match a one record to a list with multiple like records and only retrieve from the first record: Record 1 Jim Smith look up to Record...
May 11th, 2010 11:31 PM
by L. Howard Kittle Go to last post
1 273
reset defined ranges by Greg
hi, is there a way to reset (not just delete) the named ranges back to the original references so the formulas would still work? Using Excel 2007 thank...
May 11th, 2010 10:38 PM
by Greg Go to last post
3 325
VBA part of cell content by Jack Sons
Hi all, I want to do something (change font size and font color f.i.) with the part of the content of the active cell that is between the second and the...
(Multi-page thread 1 2)
May 11th, 2010 09:50 PM
by Jack Sons Go to last post
10 625
Why does row one always appear at the top when page down by Alpan
Opening sheet shows rows i to 36. When I page down the sheet shows row 1 at the top and then rows 37 to 71. The next page down and all subsequent key...
May 11th, 2010 09:43 PM
by Mike H Go to last post
1 252
When using subtotals in Excel, how do you bold the dollar amount? by guntergal
I am trying to create a report using Excel that I use subtotals for. I sort it by Department and I always get the department name bolded, but have to...
May 11th, 2010 09:36 PM
by Tom Hutchins Go to last post
1 247
Row select mode to highlight active row of active cell by Bart Fay[_2_]
Yet another simple convenience for folks with large spreadasheets. Whatever row and/or column you are in gets highlighted. Sure, you could select the row...
May 11th, 2010 09:34 PM
by Bart Fay[_2_] Go to last post
0 249
Cntl Key move/select to change in value by Bart Fay
Just another convenience key sequence to make my life easier. Sure, maybe I could do it with a macro. But, it seems like a nice little obvious addition...
May 11th, 2010 09:26 PM
by Bart Fay Go to last post
0 181
#DIV/O! Errror with Absolute Number Calculation by Brent
Hi, I am calculating the following formula. =ABS(K41-J41)/ABS(K41) The result is #DIV/O! many times because K41 is 0 and the result is #DIV/O! I'd like...
May 11th, 2010 09:26 PM
by Mike H Go to last post
7 296
VLOOKUP #REF error by Lost in Microbiology
I have a vlookup that works for the first 14, columns I want to reference. But when I get to the 15th column I get the #REF error. This is the...
May 11th, 2010 09:24 PM
by Jim Thomlinson Go to last post
3 340
Case Statement Format for getting cell value from a worksheet by George
Good Afternoon, I need to create a series of Case conditions based on the value of a cell on a certain worksheet in my open workbook..For the life of me I...
May 11th, 2010 09:22 PM
by Mike H Go to last post
1 269
ctrl+F command by pierre
hi all i use the ctrl+F to find a specific number within a column, but sometimes excel tells me that the data couldnt be found , knowing that the required...
May 11th, 2010 09:14 PM
by David Biddulph Go to last post
1 223
Input from remote 10-key and laptop numbers very slow by Gale
The last few days I've experience a delay when inputting numbers into Excel 2000 worksheets. When I type in the numbers, they slowly enter themselves, one...
May 11th, 2010 08:45 PM
by Gale Go to last post
0 214
If Vlookup Question by Brent
Hi, I have created the following equation using VLOOKUP... =VLOOKUP(D26,'Sales Averages'!$A$4:$M$5000,4,FALSE) The result varies depends on my data, but I...
May 11th, 2010 08:26 PM
by Dave Peterson[_2_] Go to last post
3 258
Sorting multiple columns that have similar data by RaqAc
I am trying to sort a worksheet where multiple colums contain the same type of data; the data duplicates down a column but not across a row. I can't figure...
May 11th, 2010 07:53 PM
by RaqAc Go to last post
0 204
Add standard header and footer to new worksheet by Grey Old Man[_2_]
I am a VBA novice writing an Excel 2002 template. I wish to add a standard header and footer to any new worksheet that is added. My attempt to achieve this...
May 11th, 2010 07:18 PM
by Grey Old Man[_2_] Go to last post
2 311
"Hidden" worksheet? by mchater
Excel file is in a shared folder. For one user only, the file opens but worksheet is not visible. Blank blue screen, no grid. File shows up in Page Preview...
May 11th, 2010 06:50 PM
by Bob I Go to last post
4 197
Percentage Formula by rosiesims
So here is the situation Currently at 150 and over the next year we want decrease to 24% of that So end result to be 114 How do I show each month as a...
May 11th, 2010 06:49 PM
by Bob I Go to last post
6 190
Post New Thread


Display Options
Showing threads 1061 to 1080 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 02:09 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.