Kenneth Barber
My feedback
-
6 votes
-
4 votes2 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
2 votes6 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Kenneth Barber commented
Roy, there's no need to be dramatic. If you're going to disagree, you are better off explaining why rather than emphasizing your disapproval.
-
4 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
2 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
16 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
3 votes0 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
2 votes1 comment · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
Kenneth Barber commented
If you go to the Review tab in the Ribbon, you'll see Protect Sheet and Protect Workbook. How is your suggestion different from Protect Workbook?
-
2 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
2 votes0 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
42 votes9 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Graphics · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
10 votes4 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
Kenneth Barber commented
Here is a demo file:
http://www.mediafire.com/download/34h0il4faompp84/Timeline_Disconnection.xlsb
You should consider using tables. There is a "Format as Table" button on the Home tab. This will let you write TableName[Column Name] instead of B10:B. It's more readable and just as futureproof. Also, TableName[Column Name] refers only to the cells in your table, whereas B10:B refers to cells in your table plus all of the blank ones underneath.