Gray area at spreadsheet
When I open various Excel spreadsheets, the entire area below the data is all
grayed out and I can't make it disappear. I want to copy and paste some
additional information in that area but when I do, it stays gray. I've
checked the fill and pattern buttons, but neither of those rectify the
The rows below your data may be hidden.
Click the small grey rectangle above the number 1,
and to the left of the letter A.
On the top toolbar click > Format > Row > Unhide.
"barlep" <email@example.com> wrote in message
I have a worksheet that has student numbers in column 1 and then their
15 course requests across columns. I need to get that information into
a row format that lists their student course requests in rows, i.e.,
A1:A15 would contain their student number and B1:B15 would contain
their course requests. Any suggestions on how this can be done?
scorer1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24644
View this thread: http://www.excelforum.com/showthread.php?threadid=382316
...Named range using conditional formatting #2
I have a named cell called Econvert which contains the conversion rate
from Dollars to Euros. I am creating a template for others to use and
I need to add a conditional format for when users forget to divide
their inputs by the Econvert.
For example, if they enter a salary number as $40,000 I want them to
divide this number by Econvert so that the end result is
=$40,000/Econvert. I would like the cell to become red if they forget
to divide by Econvert which is why I think that conditional formatting
Any ideas? Thanks in advance.
Is it any limitation to setup outlook rules wizard? say,
number of rules, etc?
...Which Upgrade Do I Need? #2
I thought I posted this an hour ago, but it didn't take.
I am trying to help someone upgrade their copy of M/S Office.
They are running OS 10.3.6
Their M/S Office Apps all say they are version 10.0.0
When I downloaded what I believed was the correct Updater, version
10.1.6, I got the alert message that Office X 10.1.6 Update cold not
locate the correct version of Office on your machine. Please see the
requirements on the download page to ensure that you are running the
correct Update for your version of Office.
On the Macopia page, Office 2001 is for OS 9 and they don't have
O...Seks v polnolunie #2
Nedotroga znakomitsya s dildo
...Outlook spellcheck #2
I am having problems with O.E. spellcheck. I keep getting
an error message. I've tried to get help from Microsoft
Tech Support but haven't had any luck. Apparently it has
something to do with the connection between my Microsoft
Word program and Outlook Express. Any suggestions?
How To Fix spell checking in Outlook Express 6
Spell check not working in XP Outlook Express
Spell Checker Not Working in Windows XP
...Scrolling with CScrollView
Let me start by saying that I'm rather new to scrolling. I have come accross
the following problem. I created a new SDI MFC application that uses
CScrollView with Visual Studio .NET 2003. Then I have increased the size in
CScrollView::OnInitialUpdate() to 1000 by 1000. Finally I have added the
following code in CScrollView::OnDraw(),
// TODO: add draw code for native data here
str_scroll.Format(_T(" x = %i y = %i "), GetScrollPosition().x,
pDC->DrawText(str_scroll, -1, &...SBS Default Web Site & Microsoft CRM Version 1.2 & Host Header Value
I have set up a test enviroment with SBS 2003 premium running MS CRM 1.2.
I have a problem that both the default web site and the Microsoft CRM
Version 1.2 web site have both been assigned the same 'Web site
identification' in this case the server IP address 192.168.16.20.
While the CompanyWeb has also been assigned the same 'Web site
identification' it has had a host header value setup for it allowing it to
My understanding it that there are three ways to distinguish web sites;
1. IP Address
2. TCP Port
3. Host Header Value
The first two are not an op...Scrolling sync subforms
I have a continuous subform which shows all claim details, that have Part(s)
against them. The claims are a one to many with the Parts. I wanted to show a
count on the form of parts against each claim. If I add a count to the
recordsource query then I lose the ability to edit the data in the subform. I
need to do this to add a Selector code if the user wants to mark the claim as
Instead I have created another continuous subform, this has just the claim
ref and the count of parts. Each form has the same sort order and a vertical
scroll bar - is it possibl...Scroll-me-down
I am using RichEditCtrl and all the associated select, format, replace for
adding text to the end of my rich edit box.
However, I have yet to figure out a definative way of making it scroll down
as far as needed (bottom of page if page length is greater than height), it
sometimes works, if the cursor position is right at the very end of the text
when the text is added programatically, but I need a way for when it is not.
Could anyone give me any tips?
Mark Randall wrote:
> Hi there,
> I am using RichEditCtrl and all the associated select, format, repla...scroll bar gone
hi have money 2005 premium and in my checkbook area where you pick the
category the scroll bar is gone and it only shows me the categories that fit
in that window. if i go into split and select the categories from within
there the scroll bar is there. Does anyone see this problem or have a fix
In that nobody else has M05, it would be hard to comment.
"Mike I" <firstname.lastname@example.org> wrote in message
> hi have money 2005 premium and in my checkbook area where you pick the
> category the scroll b...setting print area for multiple worksheets at once
Looking for a way to set the print area on a large number of simiarly
formatted worksheets at once. Ideally want to incorporate it into a
macro that does some other basic stuff as well.
Thanks for any suggestions!
annabel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26520
View this thread: http://www.excelforum.com/showthread.php?threadid=397879
Good morning Annabel
This code will loop through all your worksheets in a workbook and se
the range to A1:F30.
Sub Se...Can you reset size of bar in scroll bar?
When working in a large Excel worksheet, the size of the scroll bar
diminishes to allow you to scroll through the entire sheet. After
intentionally deleting a large portion of the worksheet, the bar size on the
scroll bar remains the same. Is there a way to reset the size of the bar on
You have to delete the rows (not just clear the contents), and then, the
easiest thing is to save the workbook.
Juan Pablo Gonz�lez
"vsholl" <email@example.com> wrote in message
> Whe...Outlook Plus #2
Never heard of Outlook Plus! , where did you buy it ?
Geoffrey McGill <firstname.lastname@example.org> wrote:
> Never heard of Outlook Plus! , where did you buy it ?
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is the domain.
I don't speak for Smiths, and Smiths doesn't speak for me.
...Scroll the screen view with the scroll bar
On some of my Excel sheets, the screen doesn't scroll along when I move the
scroll bar. It just jumps to the new location when I stop moving the scroll
bar. What is the correct setting to change so that the screen scrolls at the
Do you use different versions of excel?
In earlier versions, when you moved the scrollbar, you saw a little yellow
tooltip show you what row you were on. In newer versions, the screen moved.
(I've forgotten the version that first added the live scrolling. Maybe someone
can chime in with it.)
> On some of my Excel sheet...Graph with too many points
I have a graph with a lot of points, so I wanted to create some kind of
horizontal scroll bar so I would be able to use a better scale and move
around my time line ? Has anyone of you done something like that ?
giselle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24222
View this thread: http://www.excelforum.com/showthread.php?threadid=378389
Jon Peltier has written an article on the subject.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=...Outlook extremely slow #2
Outlook had been working fine until I installed Norton
Antivirus. It now takes several minutes to load. Could
this be the problem? Is there any way to fix this?
Which version of outlook and Norton? Try disabling the email scanning and
see if it speeds it up... also, NAV has an office scan you can disable in
NAV's options menu. if you use word as your editor, that could be the cause.
"HJ" <email@example.com> wrote in message
> Outlook had been working fine until I installed Norton
> Antivirus. It ...Tender Summary Report #2
We want a Tender Summary Report for a day (or days) including transactions,
work order and layaway. Our current Tender Summary Report can only show the
transactions. We've tried to update tendersummary.qrp, but couldn't work out.
We still want the same group method: Register.description as first column,
then tender type, Amount (or Deposit for Work Order), transaction #/Work
Order#. Is there any way to do it?
There is one report avaialble under Utiliities > Crystal Report >
RegAnaly.def (Register Analysis Report) . and I think this will help you what
What are *.stf files created in \exchsrv\mdbdata folder?
Suren Pillay wrote:
> What are *.stf files created in \exchsrv\mdbdata folder?
XADM: .stf Files May Appear in the Folder That Contains Database Log Files
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of included script samples are subject to the terms sp...Is this possible? #2
What I'm trying to do is find a way to automatically
update the hour meter readings on a second separate Excel
spreadsheet when I update it on the first hour meter
readings of the first spreadsheet.
As simple as linking the second sheet cells to the first sheet cells.
In Sheet2 in A1 enter =Sheet1!A1
OR just copy the readings cells on Sheet1.
Click on Sheet2,select a cell and Paste Special>Paste Link
The not-so-simple is you may require more than this. i.e. you want the past
hour's readings on the second sheet to remain and the new readings added.
Post back with mor...SharePoint Scroll Bar
I'm quite new to SharePoint and I was wondering how to disable the Scroll Bar in a content query web part.
Submitted via EggHeadCafe - Software Developer Portal of Choice
JQuery and partial views in an ASP.NET MVC application
Try to overwrite it with CSS overflow:hidden
Shady Khorshed - SharePoint MVP
<Daniel Arnold> wrote in message
> I'm quite new to SharePoint and I was wond...Summation of 3 biggest numbers... #2
hi all, is there any quick method to add up 3 biggest numbers in a se
of number? e.g.
I have the following data in a row:
100 20 90 30
And I want to add up 3 biggest numbers, i.e.
100 + 90 + 30 = 220
lau0001's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3332
View this thread: http://www.excelforum.com/showthread.php?threadid=53144
thanks all, I have solved the problem by "large" function.:)
-----------------------------------------------------...creation of synchronization log messages #2
I have outlook XP on win2k, and my deleted items folder is being
filled by "synchronization log" messages at the rate of 1 per minute.
They appear to be simply a log (no problems indicated). Here's a sample from
16:44:06 Synchronizing Hierarchy
16:44:06 Synchronizing Favorites
16:44:06 Synchronizing Folder 'Inbox'
16:44:08 Microsoft Exchange offline address book
Where is a setting in outlook where I can disable this?
...Vertical Scroll Bar #2
I was hoping someone could help me with this...
sometimes when i have a lot of data running down my
spreadsheet the vertical scroll bar block becomes very
small to accomodate the amount of data i have. but then
when i get rid of a lot of the data the length of the
vertical scroll bar block stays very small despite me only
having say 50 rows of data.
what i would like to know is whether there is a way to
make the vertical scroll bar block come back to bigger, so
it's easier to grab than when it is very tiny???
Select the first blank row below your data, say...