Posted  by  admin

Excel Works

Select a Worksheet Insert a Worksheet Rename a Worksheet Move a Worksheet Delete a Worksheet Copy a Worksheet

10 Date and Time: Learn how to work with dates and times in Excel VBA. 11 Events: Events are actions performed by users which trigger Excel VBA to execute code. 12 Array: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. Tatsuo Horiuchi, a 74-year-old Japanese artist, took the simple idea of an Excel spreadsheet and turned it into an unexpected beautiful work of art. Horiuchi started to use Excel to create art.

A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

Select a Worksheet

When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its sheet tab at the bottom of the document window.

Insert a Worksheet

Excel Works

You can insert as many worksheets as you want. To quickly insert a new worksheet, click the plus sign at the bottom of the document window.


Rename a Worksheet

To give a worksheet a more specific name, execute the following steps.

1. Right click on the sheet tab of Sheet1.

2. Choose Rename.

3. For example, type Sales 2016.

Move a Worksheet

To move a worksheet, click on the sheet tab of the worksheet you want to move and drag it into the new position.

1. For example, click on the sheet tab of Sheet2 and drag it before Sales 2016.


Delete a Worksheet

To delete a worksheet, right click on a sheet tab and choose Delete.

1. For example, delete Sheet2.


Copy a Worksheet

Imagine, you have got the sales for 2016 ready and want to create the exact same sheet for 2017, but with different data. You can recreate the worksheet, but this is time-consuming. It's a lot easier to copy the entire worksheet and only change the numbers.

1. Right click on the sheet tab of Sales 2016.

2. Choose Move or Copy.

The 'Move or Copy' dialog box appears.

3. Select (move to end) and check Create a copy.

4. Click OK.


Note: you can even copy a worksheet to another Excel workbook by selecting the specific workbook from the drop-down list (see the dialog box shown earlier).

While most see Microsoft Excel as endless blank rows and columns, others view it as a platform to bring their artwork to life.

Many have managed to push the limits of the spreadsheet-making software that most of us try to avoid at all costs. From landscape masterpieces to recreations of our favorite video game characters, Excel has been unexpectedly used as a drawing tool to create some of the coolest illustrations.

See also: 6 Entertaining Games Made Entirely in Microsoft Excel

Below, we've put together 10 incredible works of art made in Microsoft Excel.

Excel Freelance Work At Home

1. Japanese art by Tatsuo Horiuchi

After watching his co-workers use Excel, 74-year-old Japanese artist Tatsuo Horiuchi began to experiment with the software. He mastered how to use the spreadsheet-maker's autofunction feature, and has designed beautiful works of traditional Japanese art.

When he entered and won an Excel autoshape contest in 2006, his work received attention and made its way around the web.

To see more of Horiuchi's work, visit his website here. If you can't read Japanese, you may want to use a third-party translator service or your browser's translator tool to navigate his website.

2. Mona Lisa

The world's most famous painting by Leonardo da Vinci still looks impressive in Excel form.

But don't be so quick to think this took a lot of time and effort. Flickr user Amit Agarwal admitted to using an Excel art software that automatically converts images to pixel art. Many generators like Think Math's Pixel Spreadsheet will easily let you to turn an image into pixel art in less than a minute.

3. Avatar

Don't let this spreadsheet fool you either. Like Mona Lisa above, this scene from the science-fiction movie Avatar was generated with an Excel art generator. But it still gets cool points.

4. Drawings by Danielle Aubert

The designs above were published in artist Danielle Aubert's book 16 Months Worth of Drawing Exercises in Microsoft Excel. Aubert says her 'drawings were created by changing cell preferences for background color, fill pattern and border styles, and from time to time inserting 'comment' boxes and letters or words.'

To see more of Aubert's work, visit her website here.

5. Nyan Cat

Nyan Cat is a YouTube video, an Internet meme and now an Excel spreadsheet. In the image above, Imgur user Michelleasaurr recreated the famous animated cartoon cat with a cherry Pop-Tart body flying through outer space.

6. Super Mario Bros.

Here's another impressive sketch by Imgur user Michelleasaurr. This scene from Nintendo's popular Super Mario Bros. video game was created entirely in Excel.

Excel Worksheet Sm

7. President Obama

Excel can create beautiful portraits of humans, too. DeviantART user Katak888 from Indonesia used pixel art to depict a highly detailed portrait of President Obama.

8. Batman

Everyone's favorite fictional superhero comes to life in this Excel sketch. DeviantART user Katak888 used the software to recreate Batman swinging on a rope while wearing his iconic cape and mask.

9. Pikachu

Pikachu, one of the most famous and lovable Pokémon creatures, is shown in this spreadsheet by Imgur user VagabondGiraffe.

10. Grand Theft Auto

Chilean artist Felipe Velásquez, who goes by Shukei, has made a hobby out of Excel art. Using vectors and the autoshape tool, Shukei has created numerous illustrations, and has recorded his process in creating them on his YouTube channel.

Excel Worksheet 1

The Grand Theft Auto drawing (seen above) took him 12 hours to design, but in this YouTube video, you can watch him draw it in a nine-minute time-lapse.