Are there shortcut keys in Excel for Cell Alignment?
Press Alt and then press Ctrl+tab twice, and then use the right arrow key to move along. "Red.MnM" wrote: You can use Ctrl+1 which will take you to the "Format Cells" box and then Ctrl+PgDown will take you to the "Alignment" tab and then you can just tab thru to the different alignment positions. R... 20 May 2010 08:22
ID number to Gender
I want to see if the employee is a male or female from the ID number? ID number - 751105 0 931087 The SEVENTH number will tell you if the employee is a male or female 0-4 = Female 5-9 = Male What formule can I use? ... 20 May 2010 06:13
Excel hyperlink within workbook and SharePoint drafts
For some reason, this solution didn't work for me, so I put together a formula that when used in conjunction with the HYPERLINK formula sidesteps the issue quite well. =CONCATENATE(SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[",""),"#") Define the formula as DocLocation and specify hyperlinks... 20 May 2010 03:00
Need help on a formula
I need a formula to calculate the following information please: I will have someone enter a time (ex 6:31) in cell C3. If the time matches one of the times in cells B17-B22 I need it to display 4.6, if it matched one of the times in cells B23-28 I need it to display 4.7, if it matches one of the times in cells ... 20 May 2010 00:52
Column that needs separation
I am very new with excel and I am putting together a worksheet that has a column consisting of two primary names. I would like to format the entire column with the result being both names having their own color throughout the column. Alternatively, I could go to each row and highlight the name but there are a... 19 May 2010 21:36
Can I have a list of reserved words in excel column name?
I created several columns (fields) in my excel table, one of the column is named as "SIZE". Could you please advice if "SIZE" is one of the reserved words restricted to be used in Excel especially when creating a new column name? Can I have a complete list of reserved words that are restricted in excel col... 19 May 2010 20:31
Conditional Format with Name Range?
I have the following that I would like to do. There are two separate worksheets within a workbook: worksheet 1 and worksheet2. On worksheet2 I would like to highlight the cell if it does not match up with a particular cell on worksheet1. On both worksheet 1 I have named some name ranges: CurrentName. So o... 19 May 2010 19:24
Macro to copy/paste from one workbook to another
My original macro looked like this: Sheets("Inv_Load to Lawson").Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Workbooks.Open Filename:= _ "X:\Legal to Accounting Check Requests\Sales Tax\slsTax dbapcvi.c... 20 May 2010 16:08
How do you lock a cell with data but still allow new data entry?
I have a spreadsheet that will be accessed by multiple users. Each user will fill out a row of data, save and close the spreadsheet. We do not want users to edit rows after data is entered into a row of cells. Is there any way to lock this data to prevent it from being edited? Thanks ... 19 May 2010 17:10
Fit Row Height for Cell with Text from Formula
I am creating a calendar with a "graphical" calendar display on one tab and a list display on another. I have populated the "graphical" calendar tab by using lookup formulas that reference the list. My problem is that sometimes the text is too long to display in the cells as I have them sized. I would like s... 19 May 2010 16:03