I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.
Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.
What is this? And, how do I set it up in a spreadsheet if I need to?
Im using a table so I can sort diffrent catagories and I'm trying to put other functions to the right of the table I noticed as I change the sort on the table is moves the information outside the table as well is there a way to seperate that information or do I just need to move it above my table?
View 2 Replies View RelatedI need a macro that can search text cells in column L for a space delimiter, then if the space is present, to split that cell into a row inserted below it, then copy the information in the rest of the row down. I'm not really up on my VBA.
i want to copy a cell value to rest of the cells in the same column upto the last value in that column has the value of "FIN"
View 2 Replies View RelatedI am trying to extract some data from a cell leaving the rest of the cell untouched.
I would like to extract C:UsersDanMusicIan MusicKaraokeKaraokeBob Marley & The Wailers - Jammin'.mp3 from the cell leaving Bob Marley & The Wailers - Jammin'.mp3 in the. I have to do this to 3000+ rows.
I have a scheduling tool that I need to do the following with -
Allow user to select a range of cellsUser types a value (non formulaic just plain text)Value gets populated to all selected cells
The reason I'm not just using fill handles is because of the amount of formatting in the cells.
I opened an Excel file, and the whole page is grey. I can't see the cell lines at all. How do I get it back to white with all my gridlines?
View 3 Replies View RelatedI've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work?
View 6 Replies View RelatedPaste Special is no longer available in the Edit menu--it's grayed out. (I am using Excel 2003). I can't find any info on what disabled it or how to re-enable. It's probably something moronically obvious, but this moron needs a shove in the right direction.
View 6 Replies View RelatedI have noticed that the submenus for the following main menu items are disabled
Edit Insert Format Data
The submenus for the other main menu items are fine.
I have not run any macros that alter the menus.
I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,
The Autosum in all my Excel files is greyed out. I am able to use the icon button to perform autosums but am unable to turn off "autosum" from the tool bar. I have turned the EnableAutosum to "true" in the Editor with no luck. What am I missing?
View 2 Replies View RelatedI would like to restore some important functionality in Excel 2007 which has become disabled for a spreadsheet which I saved in different file formats.
I opened an Excel 2003 file with Excel 2007 and used 'Save As' into different formats (default, macro-enabled, binary) to see the resulting file size.
A number of Ribbon items are now greyed out for this file, including,
- Insert - Tables, Illustrations, charts, etc.
- Styles - conditional formatting and Format as table,
- Formula Auditing
- Data - just about all of them
- View - some of the Window items.
Also, I cannot resize or move a button on a worksheet.
Attempts to 'Save As' into the Excel 2003 format cause Excel 2007 to hang.
What caused so many features to become disabled?
How do I restore them?
In some excel files the redo / undo buttons are grayed out
View 3 Replies View RelatedMy spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????
View 4 Replies View RelatedI am using Excel 2000 on Windows 2000. There are no macros on spreadsheet and no protections at all yet I acnnot use trace precedents/dependents as the items are greyed out.
View 2 Replies View RelatedI've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below
pukks Auto Merged Post;Doh Doh and double doh!
Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.
I am using excel 2007 and when I right click on the worksheet tab, delete is greyed out. My workbook/sheet is not shared. I also had the problem owith row and columns. CommandBars("row").Reset sorted that out but I can't seem to sot out the tab issue.
View 6 Replies View RelatedI've got Combo Boxes and at times I want to hide this. However, when I do, the combo boxes don't hide and are still visible. Here are my steps: Right Click on the combo box, chose Format Control, then under the properties tab, the choice to select "Move and size with cells" are greyed out.
View 4 Replies View RelatedI cannot figure out why this setting has changed. When I right click my tab worksheet in Excel to copy or rename, it does not allow me. I will need your advice to re-activate that options so it is visible and not gray. I tried in the VBA workbook properties settings with no luck and also Tools, Options.
View 6 Replies View RelatedI'm using Excel 2010 and when I highlight a range and right click 'name a range' is greyed out. I can bypass this by going to the formulas tab and defining a name from there.
Anything I can check to see why this is not an option for me?
I ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).
View 9 Replies View RelatedI know EXCEL has functions for both the NORMAL DISTRIBUTION and the
cumulative value thereof...
but is it possible to graph this data..
(I imagine if I sort the data and then calculate the ***. distributions into
a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?)
I am making a spreadsheet in which I have been asked to have certain column greyed-out based on an answer that was given in a dropdown menu. Specifically, a dropdown menu in column D asks if the client was a Youth or an Adult. Depending on what the anwer is, other columns in the spreadsheet will be greyed-out; different ones for each answer. My problem is, I need this to occur for the active row being editted. For example: The first row that the user can input data into is row 4. If D4 is answered with "Adult" then certain other columns are greyed-out. However, if the next time the user updates the spreadsheet with information for a different client (now entering information in row 5) and they select "Youth" for column D5, then different columns get greyed-out. The columns that are greyed-out will depend upon the answer for the dropdown menu in column D for whatever row is actively being editted.
View 5 Replies View RelatedI keep reading that this "Application.Dialogs(xlDialogPrint).Show" brings up the same dialog as File-> Print or Cntrl+P but it does not.
Instead I get this wrong.jpg
When I actually need this correct.jpg
How to get the second one?
Say I measure the height of 1000 people and I have those in a column in excel. It should be a normal distribution with mean x and standard deviation y. How do I actually graph it so I can see the normal distrubution curve that looks something like this:
[url]
I tried making a scatter graph but it graphs them point by point. I want the height to be on the x axis and something like frequency on the y axis.
I have a value say £11.50 what i need is for this to be turn in to 1150 no point.
When i try on excel i get it to 115
i have some number that i want to put in a normal distribution
so.. i have age ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and have the number of times that the kid wake in the night ( 10, 12, 9,11,8,9,7,9,11) and want to do the normal distribution grafic with that .
How to crate a chart for normal distribution for a set of datas. say marks of students/ number of students in a class
View 1 Replies View RelatedI'm trying to make a bell curve (normal gauss distribution). I have some problems regarding the probability density curve, since its values are so low. If you look column N in the attached file - I used the NORMDIST command. Values should be somewhere between 0,2 and 0,4 - but they're about 100x lower.
View 2 Replies View RelatedI am currently using Excel 2007 and I am trying to find a good working formula for Normal Hours worked:
I have the following code for Total Hours, Time and a Half and Double Time hours but I can't seem to get the right formula for working up to 8 hours.
Whereas C11 = Total hours added for the day.
=MOD(SUMPRODUCT(C8:C10-C7:C9),1) =Total Hours Worked
=Normal work hours between 0 to 8 hour work day.
=MIN("04:00",MAX(0,C11-"08:00")) =Time and a Half hours over 8 hours worked.
=MAX(0,C11-"12:00") =Double Time hours over 12 hours worked