-
Recent Posts
Recent Comments
Archives
- August 2020
- March 2020
- December 2019
- July 2019
- June 2019
- May 2019
- March 2019
- August 2018
- July 2018
- May 2018
- March 2018
- September 2017
- August 2017
- May 2017
- April 2017
- January 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- November 2015
- October 2015
- September 2015
- August 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
Categories
Meta
Category Archives: Excel
Excel: Add, remove, update drop down lists
Source: https://www.ablebits.com/office-addins-blog/2014/09/24/excel-drop-down-list/ https://www.extendoffice.com/documents/excel/2587-excel-update-drop-down-list.html#a1
Posted in Excel
Comments Off on Excel: Add, remove, update drop down lists
Remove line breaks using Microsoft Word
Find ^p, replace with Find ^p, replace with http://www.iom3.org/web-editors-community/news/2011/jun/21/how-instantly-remove-unwanted-line-breaks-when-copying-pdf
Excel: Delete blank rows quickly, change numbers to text
Source: http://www.theexceladdict.com/_t/t031008.htm Change number to text Format Cells > Number > Custom > 0 Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will … Continue reading