I have a hidden column in an excel 2010 spreadsheet. When I go to unhide it from the view menu, the unhide option is greyed out. see attachment... the original s/s may have been created in a previous version of excel or may have been a csv file, (if this point is relevant)
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…