As any regular user of any program in the Microsoft Office 2013 suite will testify it’s very easy to accidentally close a document without having first saved, and in the process lose what can potentially be hours of work. Of course we all talk the talk telling people to save, save, save as frequently as […]
Now that we know how to get around an Excel Spreadsheet,and what the basic layout looks like, its time to start looking at how to enter data. Each Excel Worskheet can have upto 16384 columns and 1048576 rows and each of the cells this creates can have 32000 characters in it (For an explanation on […]
Now that you are able to Open, Close, and manipulate your Excel workbooks and Worksheets, it’s time to have a look at how a worksheet is constructed. Each Excel Worksheet is divided into a number of rows and columns, and the intersection of each row and column is known as a cell. In Excel 2013 […]
Unless you are content with losing all your work every time you have finished with your Microsoft Excel Workbook you will need to know how to both save your workbook, and open it back up again at some point in the future. Closing An Excel Workbook There are two basic ways to close your Workbook: […]
Sometimes when you are developing an Excel application you will have one or more Worksheets that you no longer need you will want to delete them. This is very easy to do: Right click on the name tab for the Worksheet you want to delete to reveal the context menu. Select ‘Delete’ from the menu […]
If you are developing an Excel Workbook application which you will be sharing with other people, there may be times where you need to hide an Excel Worksheet. A typical example would be an application where there is some reference data in a sheet that is used by the main sheets in your application. You […]
When you are creating a multi-sheet Excel 2013 workbook, there are often occasions where you need to make a copy of one of the Worksheets contained within the Workbook. E.g. maybe you are creating a Workbook where you have information for different people stored in individual Worksheets, but the layout of each sheet is basically […]
One of the major problems Microsoft encountered with Windows 8 was the drastic change in user interface from previous versions of Windows, and caused the biggest controversy amongst Windows users since Windows Vista was launched. With the release of the free update to Windows 8.1 for all users, Microsoft has tried to reverse some of […]