Gridlines Not Showing On Default?
Oct 23, 2013I have exhausted myself looking online before I came here and have come up short.
When I create a new workbook my gridlines are off and I have select to turn them back on everytime.
I have exhausted myself looking online before I came here and have come up short.
When I create a new workbook my gridlines are off and I have select to turn them back on everytime.
I'm not sure what I have clicked on, but I have no gridlines when entering data into my spreadsheet.
View 13 Replies View RelatedIs there a button in Excel you can press that will turn gridlines on/off rather than going through the tools/options/gridlines route?
View 6 Replies View Relatedif (a) gridline can be shown in a userform to make the appearance and readability more appealing and (b) if it is possible, how do make the gridline appear?
View 6 Replies View Relatedhow to change the color of gridlines from black to blue or red?
Is it possible to eliminate gridlines from only certain rows, columns and or cells? Specifically, I would like to eliminate the gridlines from the frozen columns and rows.
View 5 Replies View RelatedNot sure how it happened, but I lost all gridlines in Excel. I was working in a workbook this morning and something happened while in there. I have gone through options/advanced and my gridlines are colored to black. Then I have also highlighted the entire sheet and selected no fill from the Home Tab. Nothing is working.
View 9 Replies View RelatedI am doing a scatter plot of several columns and have the x-axis grid lines turned on. What is apparent is that the grid lines and tick marks are slightly off. In my case, when the point value is 6.004 the tick mark and grid line for the value 6 draws through that point.
I am using Office 2003. This was tried in Office 2007 as well with the same result.
Is it possible to show gridlines in some cells and hide gridlines in others on the same worksheet? Is it also possible to isolate a row or column and change the size of selected cells without changing the size of the cells in other rows and columns?
View 5 Replies View Relatedbuilding a worksheet to list people, payrates and hours worked etc. the header needs to have fill in areas that change with the job so I entered them in the rows rather than in a proper header. what I want to do is get rid of gridlines in the first 6 rows but
leave them intact on the rest of the document. I see templates that this was done somehow.
I use webdings font with the letter 'a' to get a tick in excel but the it erases gridlines surrounding the cell i've ticked.
View 3 Replies View RelatedIs there a way to hide the column headings/row headings and gridlines automatically when a workbook is opened without having the user go to the view tab and unchecking the appropriate boxes?
View 2 Replies View RelatedAny way of displaying only certain vertical grid lines on a radar chart. I've added several blank rows of data to make the chart more of a circle but I don't want every one of the vertical lines to display. How to only show some of the vertical grid lines?
View 1 Replies View RelatedOn occasion I cut a table from a website and paste into Excel. If/when that data is subsequently deleted from the sheet the gridlines no longer show. I've tried turning the gridlines on and off to know affect. I've tried setting and clearing borders, but that made no different to the gridlines either. Even if I highlight the entire sheet and delete it makes no difference. I can't think of anything else to try.
View 2 Replies View RelatedIs it possible to remove all gridlines (except in a table) and change the background colour to plain colour (except the table) in Excel 2010?
View 2 Replies View RelatedHow can I force Excel to enter the time as PM instead of AM in a cell without typing PM or using military time? Is there a custom format that will do this?
View 9 Replies View RelatedI have a tab within a workbook where i want the user to copy a different spreadsheet into and then press a macro button to run some code, however after this button has been pressed i want this one tab to show any changes that have been made to it, i.e make the cell red or something just so i can keep track of manual adjustemnts.
I am trying to write a UDF that uses the TRANSPOSE and MMULT functions, but I keep getting #VALUE! errors...
View 3 Replies View RelatedI had set up a long time ago a macro enabled sheet in the XLSTART folder and Template folder. It used to work where any file I opened, if I clicked new sheet, the data from that file would be in sheet2. Now for some reason it's not showing up anymore and just a blank sheet appears.
View 2 Replies View RelatedHow can I set the value of a cell to give the current date when that cell is clicked or given focus. I want A5 to show as blank, nothing there, until I click the cell, or somehow select the cell, and then have it show the the current date. If I want that date I hit tab or enter and it will record it.
If I don't want to record anything i can arrow past it and it will not record anything. If I want to change it I double click or click again(If I'm in the cell already) and I can type over or just put in the date I want.
However If the user records a date in that cell and goes back to that cell do not record the default current date on tab or enter it most be double clicked in order to change it. This is a safety that they don't tab to it and past it and have it changed by mistake. Once a date is recorded they have to double click to change it.
This is not for just one cell but for the range of cells in colum A starting on A5.
I need an assistance in setting up a VBA for the default printer in my office. The issue is I want my spreadsheet to be set up to wherever I open the spreadsheet at any computers in the facility. I want the sheet to be printing out directly at the printer in my office only. Is there a way to do this?
View 9 Replies View RelatedNetworkdays on default takes saturday as a holiday. Is there a way I can undo this and have only sunday as a holiday while calculating net working days.
View 9 Replies View RelatedI want the combobox cmbBottle to show the second item in its list when the userform shows. The code below achieves this. However, after executing cmbbottle.listindex=1, the program jumps out of the initialization and goes to Private Sub cmbBottle_change() and then executes others subs called under it. I don't want this.
Is there a way to set the combobox to a default, startup display, without triggering the cmbBottle_change event?
(I have looked under the Properties window of combobox in the form view mode and can't see how to set it's value there.)
Private Sub UserForm_Initialize() ...
As per title, I have both Excel 2003 & 2007 installed - I need to set 2003 as the default for opening xls files when double-clicking but can't seem to override 2007 which wants to hog all the action. I've been through the File Types menu and selected the 2003 version of Excel as the default, but it doesn't make the slightest difference.
I have a combo box with a list of customers in a worksheet.
I would like to present "Please choose a customer" as a default once the user activate this sheet.
I am currently having an issue with the formula below showing a zero when there is no data, now i am referencing from this cell to another sheet but even with the IF(ISBLANK inside the formula on the other page it still shows a zero which is messing up what i am trying to do on another page.
This is what i am using
=(MAX(P5:P47,P60:P102,P115:P157,P170:P212,P225:P267,P280:P322,P335:P377,P391:P433,P447:P489,
P503:P545,P559:P601,P615:P657,P671:P713,P727:P769,P783:P825,P839:P881,P895:P936)
This is the cell number that has this formula which it is telling me the max number for the column - P938
I am referencing to another sheet like this =IF(ISBLANK('sheet 2'!P938),"",'sheet 2'!P938)
How i get this to stop showing a 0 if there are no data for it to search for the max?
I have a cell that contains the =Day1!G4. It reveals what is on another worksheet, but I want to be able to have the next cell be: =Day2!G4. Is there any way that I can code this without having to physically type in every cell? I tried, =Day1+1!G4 but it didn't like that.
View 12 Replies View RelatedThe formula that I came up with perfectly works well with clear values. Everytime there's a #NUM!, #VALUE! in my array, the result I want wont show up.
=(SUMPRODUCT(--($B$17:$B$22=C4),--($C$17:$C$22=$D$3),--($G$17:$G$22)))/D4
When I tried average+if and it still gave me the same error!
=AVERAGE(IF($B$17:$B$22=$C$4,IF($C$17:$C$22=$D$3,$G$17:$G$28)))
I am creating a spreadsheet system for storing school grades, and I have a sheet on my system which shows graphs of the students data, and on this sheet there are rather a lot of graphs, and its sort of a visual overload to see so many graphs on one sheet. Im just wondering if there is any thing which I could insert which would give the person using the system a choice of which class's graph they want to show.
View 1 Replies View RelatedI have a column in which all cells do a vlookup. how can i not show the #n/a ?
View 9 Replies View Related