Search
Yogesh Mhatre
- Sep 23, 2020
- 1 min
Hide Worksheets
The excel file you work on can get loaded with lot of worksheets making it difficult to navigate through the sheets
4 views0 comments
Yogesh Mhatre
- Sep 22, 2020
- 1 min
Make Data Invisible
How about hiding just a little section of data you want to hide, but you still want to be able to work with
3 views0 comments
Yogesh Mhatre
- Sep 19, 2020
- 1 min
Transpose – reverse columns & rows
Transposing simply means, converting rows into columns and columns into the rows
6 views0 comments
Yogesh Mhatre
- Sep 15, 2020
- 1 min
Autofill to save time
If you are looking for a quick way to complete the data entry in Excel, Autofill is your savior.
7 views0 comments
Yogesh Mhatre
- Sep 12, 2020
- 2 min
Paste Special tutorial
Copy pasting is one of the most performed actions in Excel. Things are, however, a lot more than simple Ctrl C and Ctrl V.
12 views0 comments
Yogesh Mhatre
- Sep 11, 2020
- 1 min
Useful Excel Tips - Part 4
The quickest way to rename a worksheet is to double click the name of the sheet and type a new name straightway.
4 views0 comments
Yogesh Mhatre
- Sep 8, 2020
- 2 min
Useful Excel Tips - Part 1
Whether you are a beginner or a pro user, saving time while working with Excel is important.
15 views0 comments
{"items":["5f71aeb6501b9b00177833af","5f71ad97d7a85c0017039717","5f71acdb2ffa6600172926b1","5f71abef654c970017bd553e","5f6ca86bcd39d50017fb86a7","5f6ca388a6d8b90017923d9b","5f6ca145db2709001761c41e","5f64aee6f4b037001703ba4e","5f64aacb5605290017099c07","5f64a5ecedd3470017e6c577","5f62117c67f77300175f6e4a","5f620bbfb5df5f00171ae075","5f609bd139e91700172fcc93","5f5f3f1d8c3fe30017a77743","5f5f3b43f6b2230017412d6d","5f5f1d343f58c100176bcc05","5f59c9b5f84b3e0034e4ce74","5f57a63e1e667800172823fc","5f5781cfb863d20017ba8d92","5f535598b460d00017fec1bb"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(191,191,191,1)"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}