Tag

Excel Archives | OXEN Technology

Delete an Excel Table without Losing Data or Formatting

By | Business Productivity | No Comments

Let’s say you’ve created a table in Microsoft Excel. You don’t want the Excel table, but you do want to keep the data or formatting. The solution is simple: convert the table back to a data range. Note: For this to work, you need to have an already completed table. Click anywhere on the table. This displays the Design tab under Table Tools on the Ribbon. A cell in the table must be selected for the Design tab to be visible. Then, on the Design tab, in the Tools group, click Convert to Range. Click Yes. Now you have a data range without table options. And that’s it!

Read More

Simple Excel Formulas: SUM and AVERAGE

By | Business Productivity | No Comments

Excel can be a powerful tool for your business, but it can also be daunting with its many formulas, charts, and formatting. Here we’ll take a look at two simple but very useful Excel formulas, and how to make them work for you. Follow these tips to add up numbers or average them! Adding Up Numbers You have multiple columns or rows of numbers. You don’t want to have to add them all up on your calculator, and you don’t want to have to re-add them if the numbers change. The simplest solution? Use AutoSum! To add up a row or…

Read More