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 RepliesI am using this code to hide or unhide rows of text on another sheet:
VB:
Sub ProcessSheet1ChangeOnCellJ7(ByVal Target As Range)
Dim sAddress As String
Dim sValue As String
'Get the address of the cell that changed without '$' signs
sAddress = Target.Address(False, False)
[Code]....
When the "Not Pursuing" list box option is selected (in cell "J7" or "J8" in Sheet 1) I need to add (or over-write) "Not Pursuing" to the range of cells in column "B" (in the "Tasks" sheet), but only for that particular Goal, meaning a limited range of cells in column "B". If the "Pursuing - Show All Tasks" option is selected for a Goal then these same cells need to be blank so that the appropriate person can enter their name into the cell.
The purpose for adding "Not Pursuing" automatically to these yellow highlighted cells is that it will facilitate filtering of tasks by individual in the "Tasks" sheet..
Again I have tried several times to upload a sample file and am unable to, which I know makes it more difficult to solve. (Is there some common mistake people make? I know it's an allowed format and is very small in file size....)
Code solution can be entered directly beneath:
VB:
If Target.Value = "Not Pursuing" Then
ActiveWorkbook.Sheets("Tasks").Rows("29:29").EntireRow.Hidden = False
ActiveWorkbook.Sheets("Tasks").Rows("30:48").EntireRow.Hidden = True
Modify my code to have the calendar appear when the cell is selected?
Right now, you have to double click before the calendar appears. Specifically, I would like the calander to appear only when cell "C1" is selected.
I have a spreadsheet with several comments with pictures on cells. I want them to show up when you select the cell, instead of having to put your mouse cursor on it. I found this code, but then it shows the comment on the middle of the spreadsheet. I want the comments to show next to the selected cell.
View 4 Replies View RelatedI have a formula that displays the 1st monday of a month, I need the formula to take into account which day is selected and then display the first of the selected days date for the month.
=DATEVALUE("1"&G7&G5)+IF(WEEKDAY(DATEVALUE("1"&G7&G5),2)=1,0,8-WEEKDAY(DATEVALUE("1"&G7&G5),2))
Is there any way to adjust it to do this the drop down box for the day will be in F9.
How to autopopulate numbers from data sheet based on Selected month.
View 4 Replies View RelatedI've got a calendar form that populates the active cell with the date i select on the calendar. However, would it be possible for the calendar to show the cell that already has a date in it?
View 2 Replies View RelatedIf I have a dropdown with
A (value 1)
B (value 2)
C (value 3)
D (value 4)
and a person selects one of those letters in the dropdown in column 1, I would like column 2 to show the number value associated with it
I'm having some trouble showing a messagebox if the user presses OK but doesn't select a folder using msoFileDialogFolderPicker.
[Code] .....
The 2 MsgBox's I've added show the same string, yet the If Not InStr line returns true regardless if ":" is in the string or not.
When i select a cell with the mouse, so its active, then i want S27 to show the location of the selected cell.
View 1 Replies View RelatedI have a worksheet that has a months worth of data on it. The sheet is divided into sections with each day of the month being given 10 rows. So day 1 of the month will occupy rows 1 to 10, day 2 rows 11 to 20 and so on.
In each of these sectors, I would like to have an editable tick list that displays when a certain cell is selected. For example in day 1, selecting cell A3 will display the tick box. If I need a tick list for each day, would I need to create a fresh userform for each day or is it possible to have just one form and have excel remember the setting.
I have created a Pivot Table to sumarize the monthly sales data.
Is it possible to select just one month and show the YTD sales?
e.g. We are in September, I select August the Pivot Table should show the August sales column and YTD (Jan to August) sales column.
I am using the following Selection_Change Event to show a UserForm when a cell in 1 of 31 named ranges is selected.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
Dim i As Long
For i = 1 To 31
If Not Intersect(Target, Range("StatPost" & i)) Is Nothing And Target.Value = "" Then
If Target.Offset(0, -8).Value = "" Or Target.Offset(0, -7).Value = "" Or Target.Offset(0, -6).Value = "" Or Target.Offset(0, -5).Value = "" Or Target.Offset(0, -3).Value = "" Or Target.Offset(0, -2).Value = "" Or Target.Offset(0, -1).Value = "" Then....................
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 RelatedI 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.
Not 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.
building 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 RelatedI have data on 400 rows. Each row has a maximum of 10 cells with data, but many have empty cells with no data. I would like to sort each row to show values of cells in sequence and eliminate empty cells. I can use the sort row function but its a long process for 400 individual rows. Is there an easier way?
View 1 Replies View RelatedI am referring to the post made by NBVC at http://www.excelforum.com/excel-gene...xcel-help.html, Try: =IF($A1="",INDIRECT("A"&ROW()-ROW($A$2)+COLUMN(B1)),"") in B2, copied across and down
I have a similar case but there are no empty rows between lists, what would be the formula to get the same results? (The transposed address should appear next to each first line of each block).
Earlier, I posted at http://www.excelforum.com/excel-gene...-one-cell.html and I got brilliant answers, I also would like to get benefit of the above mentioned formula but in cases when there are no empty rows between lists.
I have 2 different formulas that I need changed in a similar way.
The first formula is for cell AV11:
=SUM(BI11,BP11,BW11,CD11,CK11,CR11,CY11,DF11,DM11,DT11,EA11)+10
Every cell starts off blank.
What I need is for cell AV11 to always start off blank until data is entered into one of the other cells. The problem is that since the sum always needs to be +10 only when data is entered in the other cells, I don't know how to keep 10 from showing in cell AV11 when no data is typed in the other cells.
The other formula is for cell CO39:
=(CU8)+3
I pretty much need the same thing. If no data is entered in cell CU8, then I do not want cell CO39 to show the 3.