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

Posted in database, Excel | Comments Off on Remove line breaks using Microsoft Word

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

Posted in Excel | Tagged | Comments Off on Excel: Delete blank rows quickly, change numbers to text