I've applied a Fill and now can't see the gridlines....

Does anyone know how to show the Gridlines through a fill? I've searched and 
searched but can't find the answer, yet the silly thing is I know it can be 
done as I have done it before (by accident)

Any help mostgratefully received!

bestregards,

Tim
0
1/19/2005 3:37:07 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
1072 Views

Similar Articles

[PageSpeed] 19

Apply borders...

In article <62E1EA83-287A-4FE3-BEC6-7C0155EA1850@microsoft.com>,
 "FizzyBunghole" <FizzyBunghole@discussions.microsoft.com> wrote:

> Does anyone know how to show the Gridlines through a fill? I've searched and 
> searched but can't find the answer, yet the silly thing is I know it can be 
> done as I have done it before (by accident)
0
jemcgimpsey (6723)
1/19/2005 3:52:54 PM
Reply:

Similar Artilces:

Changing Fill color choices
I have looked at past questions for fill color but I cannot make it work. I want to change one of the fill color choices permanently. I make the change ; save the file ; close the file ; and when I reopen the file the color has been reset to what it was before I changed it. How do I change it permanently. Thank you, Steven From what you posted it sounds like you are doing the right things. Where are you selecting your Fill color? Any other specifics - All files or just one? Version, other problems possibly related, etc. If there are known issues I'm sure you will be informed ...

Automatic name fills in when typing email address
I have Outlook 2000, how do you set it up so that when you start typing a persons name in the To: section of an email, Outlook list the names that match, so that you can just press the enter key to list their entire email name. ...

How do I move gridlines of individual table cells?
I am creating my first Publisher document. It includes several pages of tables. How do I move gridlines of individual cells in a table, i.e. I need different column widths in different rows of the table. Grateful for any help. Hover your cursor over a gridline until your cursor turns into two parallel lines with two little arrows on each side then click and drag...it's kinda goofy because it will also adjust the outter borders as well, but you'll figure it out. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression "Catherine" <Catherine@discussions.mic...

How do I apply a combo box to multiple cells in Excel so that it .
I would like to apply a combo drop down box in Excel. However I only want the box to appear when the cursor is over the cell can anyone offer me some help on this matter? Thank you, Dwain Hi Dwain, Perhaps you are looking for Data Validation, available on the Data menu. See Debra Dalgleish's tutorial at: http://www.contextures.com/xlDataVal01.html --- Regards, Norman "DB" <DB@discussions.microsoft.com> wrote in message news:6939ADC2-CF1C-46AA-B163-BEE27E23356A@microsoft.com... >I would like to apply a combo drop down box in Excel. However I only w...

Yes
Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a question. Then that question can be answered with a filled-in by clicking in a "Yes", or "No" box. Then a "check mark" appears if their is not one, or, disappears if their is a "check mark" already present. Or, in the case of multiple responses as noted below. With the use of a conditional fill-in like box, you can enter a check-mark. [ ] Yes (or) [ ] No The boxes indicated are shade...

Apply view to all folders
Greetings, A user has numerous folders created under her Inbox in Outlook 2000. She woule like to create a custom view and then apply it to all folders automatically. I can create a custom view easily, but can't find a way to apply it to all folders other than on a one-by-one basis. Is there a way to apply the view to all folders at one time? Thanks much, Justin You can't apply it to all at once - unless you customize the Messages view. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Gu...

view applied?
What does the following WLM beta message mean? View applied not connected to imap4.xxxxxx.co.uk I had already clicked on this account and a couple of emails were downloaded. ...

fill several sheets with data from other workbooks matching criter
So far, I was able to make a macro to filter data from a project log sheet in a workbook, and copy/paste the rest of the data in each row based on criteria in column A to the corresponding worksheets with a name matching the data in column A on the project log. But now what I need to do is make a macro that will do basically the same thing, but will instead run on sheet(1) of any other workbooks with a filename that contains "RetailProjectLog" in a certain folder location on a network share. Is this possible? If so, how can I do it? I wish I could attach my sample work...

I've applied a Fill and now can't see the gridlines....
Does anyone know how to show the Gridlines through a fill? I've searched and searched but can't find the answer, yet the silly thing is I know it can be done as I have done it before (by accident) Any help mostgratefully received! bestregards, Tim Apply borders... In article <62E1EA83-287A-4FE3-BEC6-7C0155EA1850@microsoft.com>, "FizzyBunghole" <FizzyBunghole@discussions.microsoft.com> wrote: > Does anyone know how to show the Gridlines through a fill? I've searched and > searched but can't find the answer, yet the silly thing is I know it c...

M2005 Cannot Apply Epayment To Invoice
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C4AD73.81F30C10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I create invoices for payments from customers. I have those = automatically charged to their bank accounts and credited to my bank = account. When the payments hit my bank account and are downloaded into = Money, I go into the transaction and enter "Payment For Invoice" and = then try to go to the apply payment to an invoice screen but a nice = little pop up comes up in Money 2005 that says &qu...

Printing gridlines
I have a Lexmark Z605 and I check gridlines and even format the cells for gridlines but they do not print. Microsoft has a knowledge base of the gridlines not showing on the print preview but still printing , this is not my problem. The gridlines do not print. I contacted Lexmark and they suggested to change the driver to winprint and default type to RAW and to download the newest driver, neither of these suggestions worked. They also suggested that I run msconfig under the RUN program but OS 2K does not have msconfig for me to use. So I moved all the programs out of the start menu and ...

Cross Apply problem
How do I get the desired result for the following: SOURCE TABLE: USSoilLyr FIELDS: TAXOR PARTSIZE PCT_R Alfisols ashy 60 Alfisols ashy 57 Alfisols ashy 38 Alfisols clayey 85 Alfisols clayey 79 Andisols medial 50 Andisols medial 36 DESIRED RESULT (TARGET TABLE): T_Order FIELDS: TAXOR PARTSIZE PCT_R Alfisols ashy AVG(60+57+38) Alfisols clayey Avg(85+79) Andisols medial Avg(50+36) My T-SQL Code, as follows, returns wrong calculations when I manually check the results. UPDATE T_Order SET ...

Want to see only specific number of records on a form
Hi I have a form with default view as "Continuous Forms". When I openthis form I only want to see the records equal to Recordcount i.e. ifI have 3 records I should only see three records. I dont want to seean extra one record which is blank. The easy way is simply to set the allow additions to "no".(you will still be able to add records via a code, or perhaps a "add" button you provide.Or, perhaps you don't even need add record ability...Anyway...give the above a try..it will remove that extra "new record" entry....-- Albert D. Kallal (Access MVP)...

Install V10 HR after applying service pack 3
I am currently on V10, SP3 and now have purchased the HR module. I am not sure of the steps I need to take to load the HR module (we have the V10 DVD that is not sp3) Are these my steps? 1. Load the HR module from V10 DVD on SQL Server install (I was told previously to use the Add/Remove programs option and change but it still asks for the DVD) 2. Do I need to reload SP3 on server install? 3. Then load the HR module (from V10 dvd) on additional workstations? If I have to re run the SP3 I am concerned it is going to take hours to complete like original instal of SP3 If anyone has a...

Apply Multicurrency Invoices in Bank Management
I oppened a ticket to know why I cant apply Multicurrency Invoices to payment transactions in Bank Managment as it is available in Payable Management. I've been suggested to post a suggestion for that. Simply, while doing a payment in Bank Management. If the Chequebook Currency is diffrenet than the invoices currencies that you are paying againist, then you can't apply these invoices. Thus, you cant see them in the remittance advice. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestio...

How do you color fill part of a autoshape rectangle
I see within the design formats they have autoshape rectangles with part of it filled with color. There appears to be a dotted line, but no connectors. The color seams to fill to this line. How do you accomplish this? The dotted line means there is no line. If you turn off boundaries and guides in the view menu, the dotted lines disappear. The rectangles are layered. Select the rectangles and ungroup, click yes. You will see how it all is put together. -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "learning curve" <lea...

WSUS Cleanup Wizard is running 12 hrs now...
The server had WSUS 2.0 which was never used. The database file is 5.7GB I upgraded to WSUS 3.0 and then ran the cleanup wizard to try to shrink the db file. It's been 12 hours now. I am wondering how many more hours i should expect? Thanks j~ In task manager is it still running or does it give an error any errors in event log? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Second Opinion - www.PersonalITConsultant.com Free Trial Microsoft Online...

Access 2000: How to see long strings in ListBox?
In Access2003 when a string does not fit in the ListBox control, I can left-click on visible part of the string and in about 1 sec a tooltip balloon will popup and show me entire string. When is Access 2000 left-click does NOT show that tooltip. Maybe this is turned off somewhere in Options? I did not find it... How can I see long strings in ListBoxes in Access2000? any ideas will be appreciated thanks john "Naum" <Naum@discussions.microsoft.com> wrote in message news:93A85FDC-D6BC-439D-A73C-853C66B1EDD0@microsoft.com... > In Access2003 when a string does not fit in th...

unposted applied credits
how can list all unposted applied credits in AR. Thanks, Scott If you have SmartList Builder, you could use it to create a SmartList based on the Cash receipts work file. "Scott Rusoff" wrote: > how can list all unposted applied credits in AR. > > Thanks, > Scott > Create a report off RM10201 (RM Cash Receipts Work File). Add a restriction where Current Transaction Amount <> Original Transaction Amount. "Scott Rusoff" wrote: > how can list all unposted applied credits in AR. > > Thanks, > Scott > Which smartlist contains t...

Payables issue with Applied Payments and Void Check
Hi, We had a user a number of months ago apply a number of Credit Memos from a vendor to a large invoice while creating a check. Apparently the check was then void, without a normal check number leaving us with "REMIT0000000000xx" as the reference to it. We now have a situation where the large invoice and all of the credits are still showing in the system as open. The individual credit memos do not show as having amounts applied, but when we try to apply them we're told that the amount is already applied. Everything seems to be stuck in limbo, with no way to post to resol...

Cannot see songs
I recently ripped a bunch of CDs but they do not show up in my Windows Media Library. I can see them if I go to the Music file folder. Also, songs I deleted are still showing up in Windows Media What version of WMP and Windows? These problems usually indicate that you have a corrupted library. To rebuild it, follow the instructions, specific to your WMP and Windows version, at http://zachd.com/pss/pss.html#medialibrary Note that rebuilding the library will make you lose all current play counts, and possibly ratings too. Regards -- Tim De Baets http://www.bm-productions.t...

On calendars why can't I see busy/free data and why can't I use OO
When trying to schedule a meeting for anyone in/on my network I can't see busy/free data because it specifies it cannot be retrieved. It only recently started this in the last few weeks. How can that be fixed? Also, this past week I noticed that I can no longer use the Out of Office Assistant. I get a message stating that 'Your out of office settings cannot be displayed, because the server is currently unavailable. Try again later.' As far as I can tell, the server is up and running. Thanks, Jason Version of Outlook and Exchange? Was either recently upgraded? Does everyo...

How to apply a weighting
I'm trying to apply a weighting to my teams to allow for experience and size I have 3 teams which are different sizes and are different skill levels. Level 5 is the lowest skill level and level 1 being the highest skill level. Team size/level5/level4/level3/level2/level1 6/3/2/0/1/0 10/2/3/4/0/1 7/0/2/3/1/1 How do I apply a weighting to these numbers to allow for team size and experience. Can I do this using sumproduct? I tried looking at this but cant get my fragile little mind around it Thanks in advance. -- Homer J ---------------------------------------------------------------...

Mass apply or batch apply sales documents?
Is there any way to avoid manually applying payments one by one? Our current process is that we have a cash receipt batch of payments that have declined, and on a daily basis, it is reauthorized. When the payments are approved, the payments are posted without applying the payment to the invoice first. We are using GP 10. Thanks, Erin Erin, There are several third party programs that address this issue very well. Do a search on the internet and you shall find them. Best regards, Leslie Vail "Erin Black-Mitchell" wrote: > Is there any way to ...

Log files filling disk up
We have an Exchange Server 2003 implementation. It is generating 5MB logfiles every few minutes, and within a few weeks is filling the available disk space. Any advice on hoe these logfiles can be managed would be much appreciated. Thanks Dave Are you doing Exchange-aware full online backups? On Mon, 6 Sep 2004 06:44:41 -0700, "Dave Marshall" <dj_marshall@yahoo.com> wrote: >We have an Exchange Server 2003 implementation. > >It is generating 5MB logfiles every few minutes, and >within a few weeks is filling the available disk space. > >Any advice...