Excel Watch: An Official Excel Blog: “Probably the most common question the Excel team gets from our customers is ‘when are you going to add more rows/more columns/more rows and more columns’… Well, the answer to the question is ‘in Excel 12.’ Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns. That’s […]
Continue readingCreating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot: Under forms tab, click New On the New form window select Chart Wizard and Select the table, which has your data, hit OK On the next screen, add two fields for which you want to plot […]
Continue readingUsing this code you can add the same footer to all the worksheets in your workbook. It’ll ask you for Left, Center and Right footer. Please note that if you want to print all the worksheets with continious page numbers you’d have to select all the worksheets at the same time. This code will do […]
Continue reading