Paste Special Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/paste-special/ Bestselling Excel and Power BI Courses Thu, 14 Dec 2023 22:28:58 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Paste Special Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/paste-special/ 32 32 All about Excel Comments (Notes): Shortcut Keys, Customize Background & More https://www.xelplus.com/excel-comments-notes/ Fri, 15 Feb 2019 23:33:00 +0000 https://www.xelplus.com/?p=12857 Find out what the most useful shortcut keys are when working with excel comments or notes. Format a note by adding images, change font of comment and update background color, copy and paste comments and much more.

The post All about Excel Comments (Notes): Shortcut Keys, Customize Background & More appeared first on Xelplus - Leila Gharani.

]]> 3 Ways to Transpose Excel Data https://www.xelplus.com/transpose-excel-data/ Fri, 09 Nov 2018 12:02:00 +0000 https://www.xelplus.com/?p=9884 2 of the methods shown to transpose data in Excel are dynamic. Number 3 will surprise you. It will show you a simple way to switch your data from rows to columns or vice versa.

The post 3 Ways to Transpose Excel Data appeared first on Xelplus - Leila Gharani.

]]> Excel Custom Data Validation https://www.xelplus.com/excel-custom-data-validation/ Thu, 24 May 2018 06:49:00 +0000 https://www.xelplus.com/?p=10518 Learn how to create data validation rules with formulas for custom conditions, such as alphanumeric codes or ids that have to follow a specific pattern. With formula, you can check for text, numbers & length of the entered text.

The post Excel Custom Data Validation appeared first on Xelplus - Leila Gharani.

]]> Data Validation in Excel https://www.xelplus.com/data-validation-in-excel/ Thu, 10 May 2018 16:46:00 +0000 https://www.xelplus.com/?p=10873 Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation in Excel appeared first on Xelplus - Leila Gharani.

]]> VBA Copy Paste https://www.xelplus.com/vba-copy-paste/ Thu, 19 Apr 2018 17:31:00 +0000 https://www.xelplus.com/?p=10941 This tutorial shows you how you can copy and paste with VBA. You will learn the copy and pastespecial methods, as well as resize and offset properties in order to fully control what you copy and paste from ranges.

The post VBA Copy Paste appeared first on Xelplus - Leila Gharani.

]]> Stacked Column with Connectors https://www.xelplus.com/stacked-column-chart-with-connectors/ Thu, 27 Jul 2017 11:17:00 +0000 https://www.xelplus.com/?p=12136 Learn how to add series lines or shaded background to a stacked column chart by combining it with a stacked area chart. It's a good way of displaying the trend for each category (stack).

The post Stacked Column with Connectors appeared first on Xelplus - Leila Gharani.

]]>