![]() |
#1
|
|||
|
|||
![]()
I would like to get some help with Excel 2010/2013.
Is it and how it is possible to... 1. arrange dates automatically - when a person enters a month then dates appears to the DATE-column 2. freeze all the columns, that a person can edit and enter only his/her name, month, times, objects, additional information 3. can not change the size and the formation of the table Like this: ![]() |
#2
|
|||
|
|||
![]()
1. Where you type in January, enter it as the date e.g. 1/1/17. Format it to display as the you like. The format for full month is "MMMM". Then use formulas to put the dates into your table. You can get creative to have it suppress invalid dates such as February 30.
2. and 3. Use Cell/worksheet protection. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
stevecraig2014 | Outlook | 4 | 09-22-2014 07:31 AM |
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? | GracieB | Word | 7 | 10-02-2013 06:24 AM |
![]() |
robby | Word | 3 | 04-18-2012 06:37 PM |
Excel 2007 custom ribbon not showing in Excel 2010 | Paulzak | Excel | 2 | 02-17-2012 06:35 PM |
![]() |
johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |